| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto create column with unique values
Dear All
I have the following data: Sheet1 Columns: A=STATUS, C=GROUP, D=FIRST NAME, E=LAST NAME STATUS=1,2,3 the rest are text and several people can belong to the same GROUP I would like the following automation: On Sheet2, Sheet3, Sheet4, I would like column A to autorefresh with unique values for GROUP&1 sorted by 1st-STATUS and 2nd-LAST NAME Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count unique values with auto-filter on | Excel Worksheet Functions | |||
| Can we Create a column that receives unique values only? | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Auto create unique accelerators for a list | Excel Programming | |||
Threaded Mode
