Hi,
Just wondering if anyone knows how to find the last time something occurs in a list.
please see the attached, there is a list of clients and a list of times
What I want is a formula that gives you the first instance, I just used a vlookup which works fine and then I also want to find the last instance.
so for example client 1 start would be 08/05/2013 12:59 and the last one would be 08/05/2013 19:30
Thanks for you help with this
try this array formula, copied down...
=MAX(IF($A$2:$A$31=F2,$B$2:$B$31,0))
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
non array alternative in H2 and copied down
H2: =INDEX($B$2:$B$31,MATCH(F2,$A$2:$A$31))
Thanks to you both spot on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks