Hi

I am trying to work a formulae in excel which will do the following for me. I have data in two columns ,col A and col B. So col A could read like this

A B

a 1

a 2

a 7

b 4

b 5

c 1

c 3

In need excel to check the col A for any values repeating themselves, so in this case "a" repeats itself thrice. It should then check the corresponding cells in col B and check if any of the values are less than 2 and any of the values is greater than 5. If it is then it should return true. So in the first case values corresponding to "a" are 1 , 2 and 7 .Since 1 and 7 satisfy the conditions it should give me true. But for b the values are 4 and 5 . Both the conditions are not satisfied and it should throw false. For c only one condition is met and again it should give false. Hope I have explained myself clearly