excel - How can I pull any cells with a value greater than a number?

Question

I asked a similar question to this here but I realized the >=1400 can be either before or after my "x".

I'm trying to look at the number of users who are on screens larger than 1400. I have my Excel sheet, and tried doing an IF statement, but because of the "x" in the middle, it's not working properly and is instead just pulling all of the cells, even the ones with screen sizes less than 1400. I want to be able to pull all cells with Screen Resolution values larger than 1400 on either the first or second number.

All of the numbers highlighted in yellow would be the ones pulled.

I've tried doing slight variations of the =IF(--LEFT(A2,SEARCH("x",A2&"x")-1)>1400,A2,"No") but I can't find the right format to narrate that I want the formula to look at both numbers on either side of the "x".

question from:https://stackoverflow.com/questions/65622899/how-can-i-pull-any-cells-with-a-value-greater-than-a-number

Answer 1

You can try this:

=IFERROR(IF(OR(VALUE(LEFT(A2,SEARCH("X",A2)-1))>=1400,VALUE(RIGHT(A2,LEN(A2)-SEARCH("X",A2)))>=1400),A2,"No"),"")