Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make list of cells in array and checking for duplicates
I have an array B2:F11, that has text in each cell. I need to make a
concantenated list in H2 where cell values are separated by commas. I also need to make sure that the values in the compiled list are all unique, because there is a chance that the same value will exist in more than one cell. The last thing I need to do is make sure the compiled list is in descending order. Can anyone help? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking for duplicates | Excel Worksheet Functions | |||
Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
Error Checking for Duplicates in List | Excel Worksheet Functions | |||
Checking for duplicates - think this is simple | Excel Discussion (Misc queries) | |||
Make a list that excludes duplicates | Excel Discussion (Misc queries) |