Converting table?
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!
|