ExcelBanter - Prevent duplicate entries

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Prevent duplicate entries (https://www.excelbanter.com/excel-worksheet-functions/15939-prevent-duplicate-entries.html)

Teri

Prevent duplicate entries

How can I prevent a duplicate value from being entered in a worksheet?

Gord Dibben

Teri

See Chip Pearson's site.

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

Gord Dibben Excel MVP

On Thu, 3 Mar 2005 09:45:12 -0800, "Teri"
wrote:

How can I prevent a duplicate value from being entered in a worksheet?

All times are GMT +1. The time now is 02:15 AM.