ExcelBanter - NO DUPLICATE VALUE IN THE COLUMN

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

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

- - NO DUPLICATE VALUE IN THE COLUMN (https://www.excelbanter.com/excel-discussion-misc-queries/140805-no-duplicate-value-column.html)

Paulex

NO DUPLICATE VALUE IN THE COLUMN

To all
Hello, Please help me about this.

I want a formula or validatation in 1 column that pop up a message if the
data is already available or already used.

JE McGimpsey

NO DUPLICATE VALUE IN THE COLUMN

See

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

In article ,
Paulex wrote:

To all
Hello, Please help me about this.

I want a formula or validatation in 1 column that pop up a message if the
data is already available or already used.

Teethless mama

NO DUPLICATE VALUE IN THE COLUMN

Data Validation Setting tab Allow: Custom Formula: =COUNTIF(A:A,A1)=1

"Paulex" wrote:

To all
Hello, Please help me about this.

I want a formula or validatation in 1 column that pop up a message if the
data is already available or already used.

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