| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique Values in a Column
I have a table that has a column of states. I have formula that will give me
a list of all the unique values in that column: =INDEX($A$2:$A$2208,MATCH(0,COUNTIF($B$2:B2,$A$2:$ A$2208),0)) I'd like to do the same with some vba code to create a new worksheet with the values that it creates. Any suggestions? Niq |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Populate a column by extracting unique values from another column? | Excel Worksheet Functions | |||
| macro to transpose cells in Column B based on unique values in Column A | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
![Dominique Feteau[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
