Hi all,
I am struggling to figure out an equation in excel and could use some help. I am trying, in a column of numbers to find if there is a number greater than 27, followed by a number greater than 27 again. i just need a yes or no answer for the column.
for example:
2,6, 17,88,28,4,55 would be yes
1,9,33,6,7,88 would be no

Any help would be appreciated!! thank you