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

=IF(MODE([range]))=3"HiPo",.................

should give you what you want


"TORIA28" wrote in message
...
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

Hi Graham, thankyou for the help but it doesn't seem to be working. Also how
do I add to the rule so that if the mode is 2 is is "HiVA" etc, many thanks

Toria

"Graham Whitehead" wrote:

=IF(MODE([range]))=3"HiPo",.................

should give you what you want


"TORIA28" wrote in message
...
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

Try this:

=IF(MODE([range])=3,"HiPo",IF(MODE([range])=2,"HiVa",IF(MODE([range])
=1,"DR",IF(MODE([range])=0,"NiR",""))))

where [range] might be B3:I3 for John.

Copy down as required.

Hope this helps.

Pete

On Mar 9, 11:00*am, TORIA28 wrote:
Hi Graham, thankyou for the help but it doesn't seem to be working. Also how
do I add to the rule so that if the mode is 2 is is "HiVA" etc, many thanks

Toria



"Graham Whitehead" wrote:
=IF(MODE([range]))=3"HiPo",.................

should give you what you want

"TORIA28" wrote in message
...
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- Hide quoted text -

- Show quoted text -

"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