ExcelBanter - How do I set up an Excel column to not allow duplicate entries (m.

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

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

- - How do I set up an Excel column to not allow duplicate entries (m. (https://www.excelbanter.com/excel-discussion-misc-queries/28954-how-do-i-set-up-excel-column-not-allow-duplicate-entries-m.html)

Staci2s

How do I set up an Excel column to not allow duplicate entries (m.

I'd like to make sure a user can't enter duplicate data into a particualar
column in an excel spreadsheet. Any help is REALLY appreciated!

Duke Carey

Chip Pearson's site explains how to do that:

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

"Staci2s" wrote:

I'd like to make sure a user can't enter duplicate data into a particualar
column in an excel spreadsheet. Any help is REALLY appreciated!

Staci2s

Wow! Thanks for the speedy reply. Got it all figured out!

"Duke Carey" wrote:

Chip Pearson's site explains how to do that:

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

"Staci2s" wrote:

I'd like to make sure a user can't enter duplicate data into a particualar
column in an excel spreadsheet. Any help is REALLY appreciated!

All times are GMT +1. The time now is 05:05 PM.