Hi all,
Thank you for taking the time to read this thread. I am trying to find the formula to find the greatest number/date etc in a column, I'm not sure which one I should be using?
For example I have a list of dates in Column B and I want in cell A1 to show the latest date in that column, so if the dates are
21/12/2008
05/02/2009
it would show 05/02/2009 in cell A1.
Thanks
Jon
Last edited by Madball; 12-22-2008 at 09:19 AM.
Try using MAX, i.e. in A1
=MAX(B:B)
Format A1 in required date format
you only need to use the max function. max(b:B) should work. Format the resulting cell as a date
Regards
Dav
Hi,
Thanks a lot for your help, I used the LARGE formula and seems to work fine too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks