.
Hello all I have the following xls:
------------A----------------B------------- C
1------- Date------- ----Ord#------- index
2------- 01/01/06-------W333-------7
3------- 01/03/06-------W332-------5
4------- 02/09/06-------W222------- 6
5-----------------------------------
6----------------------------
7----------- ---------------Jan-06-------Feb06
8------- Satisfied
9------- Dissatisfied
In row 8 I need to avg all index that are > than 6 for the month specified in row 7 and in row 9 all that are <=6.
Any suggestion?
Thanks
Hello all I have the following xls:
------------A----------------B------------- C
1------- Date------- ----Ord#------- index
2------- 01/01/06-------W333-------7
3------- 01/03/06-------W332-------5
4------- 02/09/06-------W222------- 6
5-----------------------------------
6----------------------------
7----------- ---------------Jan-06-------Feb06
8------- Satisfied
9------- Dissatisfied
In row 8 I need to avg all index that are > than 6 for the month specified in row 7 and in row 9 all that are <=6.
Any suggestion?
Thanks