| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unique values in a cell base on another cell
I have a column with 20 cells (a1:a20). Those cells can only be filled with
5 different text values. In another column (c1:c20) I want to force a unique value being entered base on the text in a1:a20. For example: Bob 1 Sally 2 Ted 1 Ted 3 Sally 1 Joe 1 Invalid would be Sally assigning a value of 1 to two of her entries: Bob 1 Sally 1 Ted 1 Ted 3 Sally 1 Joe 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update of cell values after insert row? | Excel Worksheet Functions | |||
| Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
| pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
| Count Unique Values | Excel Worksheet Functions | |||
| display values in cell | Excel Discussion (Misc queries) | |||
Threaded Mode
