pull most recent entry from a column

AndrewM · 02/13/19

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 · 02/15/19

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 · 02/19/19

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 · 02/19/19

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

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

pull most recent entry from a column

Comments

Help Article Resources

Categories