View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Schwartz David Schwartz is offline
external usenet poster
 
Posts: 8
Default transforming rank data

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