| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need possible combinations of 7 unique characters.
Ok I have seven unique text items in two columns and need a formula that will
give me all the possible combinations in a list. The columns are as follows. Column 1 KEY KNOB 2KEY 2KNOB <blank Column 2 KEY KNOB KK 2KK 2KEY 2KNOB <blank What I am looking for is a way to list in two columns the unique combinations of Column1 & Column2 so I can insert a third column next to give a value to be used in a VLOOKUP formula. Thank You in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to pick out unique components in a list with unique and common | Excel Discussion (Misc queries) | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| function to retrieve a list of unique characters from a column | Excel Worksheet Functions | |||
| Counting unique combinations in two columns | Excel Discussion (Misc queries) | |||
| Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions | |||
![scottgorilla[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
