S
Steve
A B
1 Bill 1/1/2003
2 Ralph 11/14/2004
3 Mike 11/16/2004
4 Ralph 2/7/2005
5 Ralph 1/14/2006
7 Ralph
I am having more trouble than I thought I would with this one. Tried
to do index and match formula with small function in cell B7 that would
return 2 largest value for Ralph... in this case that value would be
2/7/2005. Column A cannot be alphabetical. Column B is chronological.
Thanks for any help, Steve
1 Bill 1/1/2003
2 Ralph 11/14/2004
3 Mike 11/16/2004
4 Ralph 2/7/2005
5 Ralph 1/14/2006
7 Ralph
I am having more trouble than I thought I would with this one. Tried
to do index and match formula with small function in cell B7 that would
return 2 largest value for Ralph... in this case that value would be
2/7/2005. Column A cannot be alphabetical. Column B is chronological.
Thanks for any help, Steve