Display the Last Entry Data

[sgmpatnaik]

Hi All


i am back again with one new doubt that is


if we maintain some data as like Sl. No. Date Product in the Sheet1 and i would like to know the last entered date in Sheet2 of Date Column. is it possible if it is then plese suggest


Hence i oblige


Thanking you

 

[Luke M]

Last date in a column:

=INDEX(A:A,MATCH(9E+99,A:A))


If instead you meant the latest date in a column:

=MAX(A:A)

 

[sgmpatnaik]

Thank Q Mr. Luke M Sir


It's working great


Thanks Once Again and You are great for me


With Regards


Patnaik

 

[Luke M]

Always glad to help Patnaik, thanks for the feedback.