index / collect questions...

AndraK

I'm trying to figure out how to find the last update in a column. The column does not always get updated when other columns do. I saw some similar looking formulas like =INDEX([Date/Time]2:Location10, MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), 7) but they don't seem to work for me - i get invalid data errors.

I am not sure if i am even approaching this correctly - any help would be appreciated!!

Andra

Paul Newcome

Try this:

=INDEX(Location2:Location10, MACH(MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), [Date/Time]2:[Date/Time]10, 0))

Paul Newcome

Are you wanting to pull the most recently updated location?

AndraK

@Paul Newcome yes, i am wanting to pull the most recently updated.

Andra

Paul Newcome

Try this:

=INDEX(Location2:Location10, MACH(MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), [Date/Time]2:[Date/Time]10, 0))

AndraK

@Paul Newcome that worked!! thank you so much!!