Forum Discussion
Help!!! how can I rank or score this???
Looking at the 3 groups below. I asked each group to give me their list of top 5. Each group was asked to rank 1-5 with 1 being the best and 5 being the least. how can I score these so the 1's ar...
Hi Roman0919
You can create a helper table giving the point score and lookup your values and replace the scores lowest to highest.
Formula reads as below:
=SUMPRODUCT(IFERROR(VLOOKUP(B3:D3,Helper,2,FALSE),0))
Attached is the solution file for your reference.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert