| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List combinations of a range
I need a formula to find the actual combinations in a 2-column, 50-row range.
Both columns are constrained to 10 text characters if that makes it easier. e.g. Data: (may be in random order) A A A B B A B B B C B C B B J A J A Looking for this result: A A A B B A B B B C J A Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
| Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
Threaded Mode
