http://www.cpearson.com/excel/topic.htm
Chuck Pearson has several methods at the above address under "Duplicate"
Pat F

"Norman H" wrote:

Is there a quick and easy way to find/search/identify duplicate enteries in
any single coulmn within a worksheet that has multiple columes of 2 to 3000
Numbers in each column