Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique data
I'm looking for formula that enable excel to prompt when the data that i'm
written is already typed. e.g cont no. abcd1234567 will be prompted by excel when i'm typing the no again. Thanks friend! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique data
Use Data Validation in the 2nd row down, with a type of Custom and a formula
of =COUNTIF($A$1:A1,A2)=0 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ShamsulZ" wrote in message ... I'm looking for formula that enable excel to prompt when the data that i'm written is already typed. e.g cont no. abcd1234567 will be prompted by excel when i'm typing the no again. Thanks friend! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
comparing two columns of data and return unique data in another co | Excel Discussion (Misc queries) | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
data reduction--goal:unique time data only | Excel Programming | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) |