SOLVED

transaction lookup

%3CLINGO-SUB%20id%3D%22lingo-sub-2889197%22%20slang%3D%22en-US%22%3Etransaction%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889197%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20can%20i%20really%20find%20the%20latest%20date%20on%20the%20left%20column%20of%20the%20transaction%20lookup.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2889197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENotifications%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPrivate%20Messaging%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2889549%22%20slang%3D%22en-US%22%3ERe%3A%20transaction%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889549%22%20slang%3D%22en-US%22%3Ehello%20guys%2C%20i%20really%20need%20help%20please........................%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891526%22%20slang%3D%22en-US%22%3ERe%3A%20transaction%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891526%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1197163%22%20target%3D%22_blank%22%3E%40Freddie10385%3C%2FA%3E%26nbsp%3BI%20suspect%20the%20reason%20you%20are%20having%20difficulty%20finding%20help%20on%20this%20is%20you've%20posted%20this%20in%20the%20incorrect%20place!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3EYou've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%20Community%20Discussion%20space%3C%2FA%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3Ewhich%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

how can i really find the latest date on the left column of the transaction lookup.

10 Replies
hello guys, i really need help please........................

@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. 

best response confirmed by Freddie10385 (Occasional Contributor)
Solution

@Freddie10385 

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.
You should accept an answer only if it really helped you and you are using the solution.
If you just want to say "thanks" then write in a posting or give a like for the answer.

And since you do not specify why my formulas do not work for you then I can't do anything more.
Should I help you? or has it been sorted
Nope... i really need help.
okay....i have understood thus am just trying to configure the page how everything works here cause am new on this platform