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.
- Oct 27, 2021
It is not clear what you mean with "latest".
Here are three ways:
=A40 =LOOKUP(9^9,A:A) =MAX(A:A)
Detlef_Lewin
Oct 27, 2021Silver Contributor
It is not clear what you mean with "latest".
Here are three ways:
=A40
=LOOKUP(9^9,A:A)
=MAX(A:A)
Freddie10385
Oct 28, 2021Copper Contributor
I want to find date lookup for my transaction lookup but it keeps on saying date lookup incorrect.
- Detlef_LewinOct 28, 2021Silver ContributorYou accepted my posting as a solution but yet it seems not to work for you.
- Freddie10385Oct 28, 2021Copper Contributorit accepted it as a token of thanks but it hasn't worked for me.
- Donald_Genes_Oct 28, 2021Brass ContributorShould I help you? or has it been sorted