I am having a hard time removing duplicate records. I have tried the
advanced filter with unique values only but it is not working since
fields contain blanks.

Is there a formula I can use instead that will remove duplicate Ref Dr
#'s?

Here is a sample of my data.

Ref Dr ID Ref Name Count
R9999 2933 FOLSOM, ROBERT J 6
R9999 10595 1
R9998 1461 NOVOA, ELIO R 15
R9998 6310 NOBOA LELIO 1
R9995 1264 MOLINET, ROLAND 18
R9995 7853 DAVILA, GUILLERMO 1
R9982 514 LEE, KEN 55
R9982 5015 2
R9982 12301 ROSEN, ROBERT 1
R9978 456 SUDIAZ, FABIO E 65
R9978 6575 CARDONA, LYSETTE 1
R9978 11301 MURUVE, NICOLAS 1
R9978 9836 1


--
Tuttamay77
------------------------------------------------------------------------
Tuttamay77's Profile: http://www.excelforum.com/member.php...o&userid=33047
View this thread: http://www.excelforum.com/showthread...hreadid=541679