Forum Discussion
Freddie10385
Oct 27, 2021Copper Contributor
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)
10 Replies
- Detlef_LewinSilver Contributor
It is not clear what you mean with "latest".
Here are three ways:
=A40 =LOOKUP(9^9,A:A) =MAX(A:A)
- Freddie10385Copper ContributorI want to find date lookup for my transaction lookup but it keeps on saying date lookup incorrect.
- Detlef_LewinSilver ContributorYou accepted my posting as a solution but yet it seems not to work for you.
- EricStarkerGold Contributor
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.
- Freddie10385Copper Contributorhello guys, i really need help please........................