I tried the formula listed below and got all "a", I must be doing something
wrong.
Here's my adjusted formula:

=IF(E3=MIN(IF(($B$3:$B$17787=B3),$E$3:$E$17787)),1 ,"a")


"Ashish Mathur" wrote:

Hi,

Assume that your data is in range E9:G14. use the following array formula
(Ctrl+Shift+Enter) in cell H9 and copy down -
=IF(G9=MIN(IF(($E$9:$E$14=E9),$G$9:$G$14)),1,"a").

Now you will see 1 against all the records which are the least. Now
highlight H9:H14 and the Ctrl+GSpecialFormulasNumbers and OK. This will
highlight all the 1's. Now do Alt + E+D+R.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Lizz45ie" wrote in message
...
I have a worksheet that has about 18,000 rows of data where there are
duplicates. For instance the required delivery date changed from February
2
to February 9 but all of the information regarding the sales order
remained
the same. I would like to delete the record with the oldest date. Is
there
a function I can use to compare the date and highlight the record that
should
be deleted?