Is there a way to prevent entering duplicate data in a range of cells within a column?
J Jana Thornsberry Nov 4, 2008 #1 Is there a way to prevent entering duplicate data in a range of cells within a column?
P Peo Sjoblom Nov 4, 2008 #2 Yes if you mean entering using a keyboard. http://www.cpearson.com/excel/NoDupEntry.aspx but it won't prevent it if someone pastes something -- Regards, Peo Sjoblom
Yes if you mean entering using a keyboard. http://www.cpearson.com/excel/NoDupEntry.aspx but it won't prevent it if someone pastes something -- Regards, Peo Sjoblom
