Lets say, you want to sort data in column B through D according to column A
but with the following RESULT. I tried to make a macro with custom list
according to colums B, C, D etc... sorted them one by one and gave the
matching numbers in column B through D a value '1' and the empty cels (to
fill up the matrix) a value of '0'. This works, but only if the column
lenght in column A isn't larger than about 180 rows. The problem is that in
my real spreadsheet I have in colums A over 4000 rows and the other colums I
made the custom lists from can be more than 180 rows. I tried splitting them
up but it's not a really good solution....
I tried to visualize it below. Does anyone has another sugguestion to do
this? Mostly want to know about the second step ofcourse. Already tried
lookup which doesn't work....for step 2....


BEGIN
Step 2
A B C D A B
C D
1 2 1 3 1
1
2 3 2 4 2
2 2
3 5 4 5 3
3 3
4
4 4 4
5 5
5 5

RESULT
A B C D
1 0 1 0
2 1 1 0
3 1 0 1

4 0 1
1
5 1 0 1



Jootje