Hi,
I have a set of numeric data in column A.
i need a formula in column B so that if 2 out of 3 consecutive values in A is greater than 5, the corresponding B column for the 2 values should show a text "High".
Col A Col B
2
3
6 High
7 High
5
3
6
3
Regards,
sreejith
Bookmarks