If Column A5:A60 is a date (example A5 = 01-01-2012 and so on) and column C5:C60 has a number.
I can use the Max function to find the highest number in C5 through C60 but how can I find the corresponding date in Column A?
Thanks.
If Column A5:A60 is a date (example A5 = 01-01-2012 and so on) and column C5:C60 has a number.
I can use the Max function to find the highest number in C5 through C60 but how can I find the corresponding date in Column A?
Thanks.
Last edited by johnsoncj2002; 11-23-2011 at 04:04 PM. Reason: Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks