| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto create column with unique values
Hello,
I suggest to take the more complex example from http://www.sulprobil.com/html/sorting.html Let me know if you need more info to adapt it to your needs. Regards, Bernd |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto create column with unique values
Thank you for your help, but is not exactly what I was looking for. I need
vba to do the following: www.mysmartnumber.com/sampledatafile.xlsx Please help, thank you "Bernd P" wrote: Hello, I suggest to take the more complex example from http://www.sulprobil.com/html/sorting.html Let me know if you need more info to adapt it to your needs. Regards, Bernd |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto create column with unique values
www.mysmartnumber.com/sampledatafile.zip
"ANDNAND" wrote: Thank you for your help, but is not exactly what I was looking for. I need vba to do the following: www.mysmartnumber.com/sampledatafile.xlsx Please help, thank you "Bernd P" wrote: Hello, I suggest to take the more complex example from http://www.sulprobil.com/html/sorting.html Let me know if you need more info to adapt it to your needs. Regards, Bernd |
| Reply |
| 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 | |||
Hybrid Mode
