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

  • Thread starter Thread starter liptonbnl
  • Start date Start date
L

liptonbnl

This will probably be really simple for most of you. This is coming fro
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 th
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
 
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")
Click to expand...

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),"not defined")
In case of a tie, select the latest date.
Click to expand...

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

Biff
 
Back
Top