I have a range of data that I would like to lookup a text in column A and then return the maximum date in column C of that range where the text in A repeats and has different time intervals. I have tried lookup, but it will only work if the data is sorted. The data may not always be sorted. If there a better formula to achieve result?
Please see attached.
Last edited by heatherromo; 03-09-2012 at 01:41 PM.
I was able to solve this with MAX function and array formula. If there is any other suggestions, I would love the input. Thanks!
a Max array formula is probably the best way to get what you are looking for in this case.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Hi heatherromo,
See the attached file where I have used the simple array formula to obtain the desired results. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks