"TORIA28" wrote:
At the end of each row I would like a formula that calculates the following:
*If someone got mainly 3's then the cell should say "HiPo" (High Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)

Suppose the scores for John are in B3:I3. Then:

=choose(1+mode(B3:I3),"NR","CR","HiVa","HiPo")


----- original posting -----

"TORIA28" wrote:
I have a set of scoring results for individuals for 8 different areas eg:
1 2 3 4 5 6 7 8
________________
John 3 3 2 3 2 2 3 3
Mark 1 1 1 1 1 1 1 1
Mary 2 2 2 2 3 2 3 2
Sara 0 0 0 0 0 0 0 0
Kate 3 3 2 2 2 3 2 3

At the end of each row I would like a formula that calculates the following:

*If someone got mainly 3's then the cell should say "HiPo" (High Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)
Thankyou for your help on this