| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can we Create a column that receives unique values only?
Is there any way where, we can create a column that will allow to enter only
unique values? If i try to enter the same value in another row of the same column and press ENTER, it should show the error! Is this possible? Just a thought! I do know that we can sort and separate the unique values in a column. What I was searching for is different from that! Thanks Nish |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can we Create a column that receives unique values only?
See
http://cpearson.com/excel/NoDupEntry.htm In article , Nish wrote: Is there any way where, we can create a column that will allow to enter only unique values? If i try to enter the same value in another row of the same column and press ENTER, it should show the error! Is this possible? Just a thought! I do know that we can sort and separate the unique values in a column. What I was searching for is different from that! Thanks Nish |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking values of column A to values of column B | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Linear Mode
