ExcelBanter - Create formula for detecting duplicates

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

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

- - Create formula for detecting duplicates (https://www.excelbanter.com/excel-worksheet-functions/29664-create-formula-detecting-duplicates.html)

Courtneyf04

Create formula for detecting duplicates

I am trying to create a formula that we warn me when I enter a number that
has already been entered. I have a column of Product Id numbers and don't
want to enter in duplicate numbers. Any help for anyone is greatly
appreciated - Thanks!

JE McGimpsey

See one answer in reply to your post of two minutes earlier...

In article ,
"Courtneyf04" wrote:

I am trying to create a formula that we warn me when I enter a number that
has already been entered. I have a column of Product Id numbers and don't
want to enter in duplicate numbers. Any help for anyone is greatly
appreciated - Thanks!

All times are GMT +1. The time now is 07:26 AM.