Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an interesting problem, I think. I've got ranking data in the
form of: 1 2 3 4 5 a c d b e c a d b e e a c d b where a, b, c, d, and e are the various choices being ranked (3 responses in this sample). How can I programmatically create a matrix as follows so that it scales easily to any number of responses? a 1 2 2 b 4 4 5 c 2 1 3 d 3 3 4 e 5 5 1 TIA, David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Data transforming and zigzag figure poltting | Excel Discussion (Misc queries) | |||
Transforming Data | Links and Linking in Excel | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |