excel

Buddy · Mar 5, 2005

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

Gord Dibben · Mar 5, 2005

Buddy

Chip Pearson shows you how using Data Validation

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

Gord Dibben Excel MVP

Buddy · Mar 5, 2005

Very helpful Thank you