This will probably be really simple for most of you. This is coming from
someone really new to excel.
I'm working on a worksheet and I can't figure out how to do this.

In case of a tie, select the latest date. And it says i can't use the
sort command.

Now i can figure out how to tell if there is a tie using
=IF(COUNTIF(I13:I43,MIN(I13:I43))=2,"Tie","no tie")

But i can't figure out how to tell it to show the latest date.

Thanks for any input or hints on what to experiment with.


--
liptonbnl
------------------------------------------------------------------------
liptonbnl's Profile: http://www.excelforum.com/member.php...o&userid=35282
View this thread: http://www.excelforum.com/showthread...hreadid=550664