Hi guys,



with a lot of help I managed to do the attached worksheet. The remaining problems are as follows:

1) From a Input-List (Matrix) (all 33 entries from B2 to D12) I need a sorted and compacted List of unique entries (First Step).

2) In the end I would like to have a List (Matrix) sorted by the Index-Word-List from Step One AND with the respective numbers (some entries from A2 to A12) from the Input-List underlined (Third Step).

Please have a look!
TIA!

Attached Files

Test 2.xlsx (16.8 KB, 15 views)

1) The formula is working, what you should know, is that you must avoid empty fields... You can have empty cells in that column, but not in the first cells in column. For example, if the formula finds 3 unique records, first 3+1 cells must not be empty, even if they have the same value; if there are 5 unique records in list, first 5+1 cells in that column must not be empty... Try typing something in cell B4, you will see that the formula works. Then, try deleting one of the first 2 cells: B2 or B3, the formula will not work again
2) This is definetely not possible with excel formulas, only VBA can help.