Forum Discussion
Solved
transaction lookup
how can i really find the latest date on the left column of the transaction lookup.
It is not clear what you mean with "latest".
Here are three ways:
=A40 =LOOKUP(9^9,A:A) =MAX(A:A)
Freddie10385 I suspect the reason you are having difficulty finding help on this is you've posted this in the incorrect place!
You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.