Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

Welthey wrote:

I am currently downloading stuff to an excel spreadsheet. I was wondering if
there is a formula or a macro that I can run in Excel to remove duplicated
account numbers that are downloaded to the form?

Can someone please advise?
Thanks.

--

Dave Peterson