Thread: [Solved] Converting table?
View Single Post
 
Old 05-10-2014, 01:57 PM
roderh roderh is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: May 2014
Posts: 17
roderh is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Test 2.xlsx (16.8 KB, 15 views)
Reply With Quote