ExcelBanter - duplicate data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - duplicate data (https://www.excelbanter.com/excel-discussion-misc-queries/209017-duplicate-data.html)

Jana Thornsberry

duplicate data

Is there a way to prevent entering duplicate data in a range of cells within
a column?
--
Sincerely,
Jana

Peo Sjoblom[_2_]

duplicate data

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

"Jana Thornsberry" wrote in
message ...
Is there a way to prevent entering duplicate data in a range of cells
within
a column?
--
Sincerely,
Jana

All times are GMT +1. The time now is 04:34 AM.