I have a spreadsheet similar to this: (may have to copy into fixed font text)
Role1 Role2 Role3 Role4 Role5 Role6
Obj1 X
Obj2 X X X X
Obj3 X X
Obj4 X X X
Obj5 X X X
Obj6 X X X
Obj7 X X
Obj8 X X
Each role (1-6) can have upto 8 objects selected.
My request is to add a new row which indicates which role is most similar to each.
Clearly, role1 and role4 are very similar so the next role for Role1 would be role4 and vice versa.
I presume a point system of matches would be needed, so for Role1 each other role and each object is compared, where equal add 1 point. Which ever role had the highest number of points is the closest match (if not a draw). If 0 then there is no match at all.
Does this make sense? The actual spreadsheet has 60 roles and 9,000 objects making it a nightmare task manually!
Any help much appreciated.
Role1 Role2 Role3 Role4 Role5 Role6
Obj1 X
Obj2 X X X X
Obj3 X X
Obj4 X X X
Obj5 X X X
Obj6 X X X
Obj7 X X
Obj8 X X
Each role (1-6) can have upto 8 objects selected.
My request is to add a new row which indicates which role is most similar to each.
Clearly, role1 and role4 are very similar so the next role for Role1 would be role4 and vice versa.
I presume a point system of matches would be needed, so for Role1 each other role and each object is compared, where equal add 1 point. Which ever role had the highest number of points is the closest match (if not a draw). If 0 then there is no match at all.
Does this make sense? The actual spreadsheet has 60 roles and 9,000 objects making it a nightmare task manually!
Any help much appreciated.