i have a column D where i have to find the places greater than 10.
1
2
3
4
10
11
4
5
6
10
11
3
i am getting an answer 5,6,10,11.
if there are 2 values one after the other which satisfy >10, i need to skip the 5,10 and display only 6,11.
my final answer should only be 6,11
please help me out
Best Answer