Counting the largest...

[arjcvg]

Hi!

For Example I have the following data

week1---week2---week3----week4----week5-----result
10--------6----------11---------2------------12---------acceptable

How can I produced a result that this is acceptable since the dat
actually move up 3 times and just moved down 2 times?


thanks a lot for your help!

a

 

[Frank Kabel]

Hi
so you want to have 'acceptable' if the data moved up more often than
it moved down? If yes try:
=IF(SUMPRODUCT(--(A22<B2:E2))>SUMPRODUCT(--(A22>B2:E2)),"Acceptable
","not acceptable")

 

[Myrna Larson]

Week 2 is down, week 3 is up, week 4 is down, week 5 is up. There are only 4
movements (not 5), and it's a tie: 2 up, 2 down.