find duplicates

[tizwaz]

is there anyway of finding duplicate values in a list in excel. I know how to do it in access but was hoping to save the time of importing the spreadsheet into access to perform the query?

 

[carrr]

See:

http://www.cpearson.com/excel/duplicat.htm

Tired of waiting for an answer? Try asking better questions. See: faq222-2244

 

[tizwaz]

thanks to you both - all good suggestions.

 

[gizmo1973]

Try this.

faq68-5446

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"