New excel user question: Incase of tie, select latest date
 

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

New excel user question: Incase of tie, select latest date
 

Hi!

Not a lot of detail to work with!

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")

Is I3:I43 a range of dates?

If there's a tie use the latest date..........the latest date means the most
recent date which would be:

=MAX(I3:I43)

If by latest date you actually mean the oldest date then that would be:

=MIN(I3:I43)

To incorporate those conditions into the above formula:

=IF(COUNTIF(I13:I43,MIN(I13:I43))1,MAX(I3:I43),"n ot defined")

In case of a tie, select the latest date.

"Not defined" means you haven't said what you want if there are no ties?

Biff

"liptonbnl" wrote
in message ...

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