Hi team!
I have a document where:
In column A, I have listed possible selections that can be made
In Column B, I have the rank of each selection, made by the owner of the document
In Column C, I have the total points that would be assigned to that selection (I’d like this calculated automatically)
For this response, I’m allowing 10 points total to be assigned and I’d like the highest ranked selection to receive the most points and the lowest the fewest, with the total for all responses adding up to 10 possible points. This is the part I’m racking my brain against.
I have also made the number of selection a COUNTA function, so that excel counts the number of cells with data in the selections column to determine how many choices are available.
Help!
I have a document where:
In column A, I have listed possible selections that can be made
In Column B, I have the rank of each selection, made by the owner of the document
In Column C, I have the total points that would be assigned to that selection (I’d like this calculated automatically)
For this response, I’m allowing 10 points total to be assigned and I’d like the highest ranked selection to receive the most points and the lowest the fewest, with the total for all responses adding up to 10 possible points. This is the part I’m racking my brain against.
I have also made the number of selection a COUNTA function, so that excel counts the number of cells with data in the selections column to determine how many choices are available.
Help!