Hi guys I’m new to excel and this forum and I am working on a spreadsheet that can recall the top 3 rankings of interactions between people in a matrix questionnaire.
For example, I sent the questionnaire to each person and they are ranking who they interact with the most - 1 being the heights level of interaction and 3 being the lowest. (see image) The ranking is done up and down and the score are taken across. The lower the score across the matrix the higher interactions they have.
\1
Now, I want to recall each person’s #1, #2 & #3 from the matrix and automatically populate it into a list like the one below (see image). I would want to automatically fill in B9:D12 from the matrix above.
\1
I actually have a 28x28 matrix that needs to rank the top 5 to 7 but I’m using this as an example. I tried to use vlookup, hlookup, and rank functions but I wasn’t able to make it work
Thanks in advance
Bookmarks