OK.

I have an excel sheet, basically using it to send out a fax blast

I have duplicate fax numbers for a ton of the records

So I used this formula: =IF((J7=J8),"Duplicate Fax","")

So if the value of J7 is the same as J8, then Duplicate Fax is placed in column K next to the record for J7

I was then just going to sort by all records that have "Duplicate Fax" in the row and delete them.

But of course with conditional formatting, this is a bitch. Is there any way to lock the result of the formula as simple text so I can sort and delete those rows?

10/1/2007 12:15:28 PM

copy - paste special - paste values only

depending on version it's something like that

10/1/2007 12:17:55 PM

Perfect... Gracias

10/1/2007 12:24:28 PM

just make a pivot table, drop the numbers into the left field...won't show any duplicates

10/1/2007 12:52:38 PM