| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Unique Values
Excel2003 ...
Col H contains up to 100 unique values Col D contains Values L1, L2, L3 out to L50 (100 repeats of this set) In Col C ... I wish a formula to return: 1st set L1-L50 ... 1st unique value from Col H 2nd set L1-L50 ... 2nd unique value from Col H 3rd set L1-L50 ... 3rd unique value from Col H etc etc until all unqiue values are populated in Col C (up to 100 sets) Thanks for the guidance ... Kha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse the signs of values | Excel Worksheet Functions | |||
| Reverse fold change values | New Users to Excel | |||
| Reverse numerical values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Reverse values but not X axis | Charts and Charting in Excel | |||
Threaded Mode
