I really need help with a rule

[TORIA28]

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

 

[Graham Whitehead]

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

should give you what you want

 

[TORIA28]

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

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

should give you what you want

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

 

[Pete_UK]

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

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

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

should give you what you want

- Show quoted text -

 

[joeu2004]

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 -----