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)
It is not clear what you mean with "latest".
Here are three ways:
=A40
=LOOKUP(9^9,A:A)
=MAX(A:A)- I want to find date lookup for my transaction lookup but it keeps on saying date lookup incorrect.
- You accepted my posting as a solution but yet it seems not to work for you.
- it accepted it as a token of thanks but it hasn't worked for me.
