preparing data for statistical analysis
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 |
All times are GMT +1. The time now is 03:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com