Multiple Cell Check without VBA

[sosag39575]

Hi,

I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved.

I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in saying Yes or No (column F should show the result)

.

Your help is appreciated

 

[FormR]

Hi, welcome to the forum!

Here is one option you can try.

Book1
	A	B	C	D	E	F
1	Date 1	Date 2	Date 3	Date 4	Date 5	Flipflopped
2	OK	50	60	OK	20	Yes
3	50	60	50	60	40	No
4	OK	OK	OK	OK	OK	No
5	20	30	OK	OK	OK	Yes
6	OK	OK	OK	OK	55	Yes
7	50	OK	OK	OK	OK	Yes
Sheet1

Cell Formulas
Range	Formula
F2:F7	F2	=IF(OR(COUNTIFS(A2:E2,{"*","<9.99E+307"})=COLUMNS(A2:E2)),"No","Yes")

 

[sosag39575]

Thank you but I forgot to add the most important item . It will not tell you that it flipped if it was consistently OK for the more recent dates (right to left). Here is an updated example.

 

[DanteAmor]

Hi, welcome to the board!

Another way

Book1
	A	B	C	D	E	F
1	Date 1	Date 2	Date 3	Date 4	Date 5	Flipflopped
2	OK	50	60	OK	20	Yes
3	50	60	50	60	40	No
4	OK	OK	OK	OK	OK	No
5	20	30	OK	OK	OK	No
6	OK	OK	OK	OK	55	Yes
7	50	OK	OK	OK	OK	No
8	OK	OK	OK	20	OK	Yes
9	20	30	80	80	OK	No
Sheet5

Cell Formulas
Range	Formula
F2:F9	F2	=IF(IFERROR(MATCH("*",A2:E2,0),6)<IFERROR(MATCH(9.99E+307,A2:E2,1),0),"Yes","No")

 

[sosag39575]

thank you

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.