10 banks 100 numbers in each bank don't want to duplicate numbers
Maybe a warning to show where the duplicated number's are?

Sample of numbers: 46.98645 to 1234.56789 scanner frequencies

Thank you

Buddy

Chip Pearson shows you how using Data Validation

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


Gord Dibben Excel MVP


On Sat, 5 Mar 2005 07:31:01 -0800, "Buddy"
wrote:

10 banks 100 numbers in each bank don't want to duplicate numbers
Maybe a warning to show where the duplicated number's are?

Sample of numbers: 46.98645 to 1234.56789 scanner frequencies

Thank you

Very helpful Thank you

"Buddy" wrote:

10 banks 100 numbers in each bank don't want to duplicate numbers
Maybe a warning to show where the duplicated number's are?

Sample of numbers: 46.98645 to 1234.56789 scanner frequencies

Thank you