Oct 26 2021 11:45 PM
how can i really find the latest date on the left column of the transaction lookup.
Oct 27 2021 01:55 AM
Oct 27 2021 09:45 AM
@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.
Oct 27 2021 10:05 AM
SolutionIt is not clear what you mean with "latest".
Here are three ways:
=A40
=LOOKUP(9^9,A:A)
=MAX(A:A)
Oct 27 2021 11:46 PM
Oct 28 2021 12:09 AM
Oct 28 2021 12:13 AM
Oct 28 2021 12:22 AM
Oct 28 2021 12:50 AM
Oct 27 2021 10:05 AM
SolutionIt is not clear what you mean with "latest".
Here are three ways:
=A40
=LOOKUP(9^9,A:A)
=MAX(A:A)