if then in whole column check

[karenbau]

Hi all,

Hoping someone can help me out with the following:

I have a excel sheet with lots of different numbers. I want to check that if column H is equal to 400006, then column F is always either blank or begins with the digit 9.

As I have to do this daily check, I would prefer to check this for the entire columns in one cell at the bottom of the sheet rather than checking this row by row.

Can anyone help me how I should go about this?

Thanks in advance,

Karen

 

[SteveO59L]

If you were to check this in one cell, what would you want to return if you had multiple entries evaluating to true.

I would suggest, that you should do this as a row by row check, then filter for rows that evaluate to true.