pull most recent entry from a column

AndrewM

I have a database sheet which is filled out using a form.  It records many different items being checked in and out using a Barcode column and a Location column.  The sheet auto fills the date that the entry is created, newest at the bottom.  Is there a way to reference the most recent location of any specific item onto a second sheet?  I would like to do this without having to reformat my database sheet to put new entries at the top.

Thank you

Paul Newcome

Try something along the lines of 

 

=INDEX({Master Sheet Location Column}, MATCH(MAX(COLLECT({Master Sheet Date Column}, {Master Sheet Item Name Column}, [Item Name Column]@row)), {Master Sheet Date Column}, 0))

 

{Master Sheet Location Column}: Cross sheet reference - The column on the Master sheet that houses the location of the item.

{Master Sheet Date Column}: Cross sheet reference - The column on the Master sheet that houses the Auto-Date for each row.

{Master Sheet Item Name Column}: Cross sheet reference - The column on the Master sheet that houses the item name.

[Item Name Column]@row: Leave the @row portion - References the column on your summary sheet (where the formula goes) housing the item name (must be an exact match to what is on the master).

AndrewM

I tried substituting that formula into my sheet, with the addition of a Value expression around the Item Name Column, since those barcodes are actually pulled from a different sheet as well.  It gave me an #Incorrect Argument Set error.

Here's what the formula I entered looks like:

=INDEX({Install / Removal Range 1}, MATCH(MAX(COLLECT({Install / Removal Range 2}, {Install / Removal Range 3}, VALUE(Barcode@row))), {Install / Removal Range 2}, 0))

Paul Newcome

What kind of data exactly is being housed in this range... {Install / Removal Range 3}...?

 

and this one... (Barcode@row)...?