Is there a blank cell in column A where the corresponding cell in column C is also blank?

[nerdshoveler]

I want to check a sheet for any blank cells in column A where there is also a blank cell in the same row but in column C. The result of the formula needs to be True or False. Example 1: If cell A3 is blank and cell C3 is blank then the result is True. Example 2: If cell A3 is blank and cell C3 is NOT blank then the result is False. If cell A3 is NOT blank and cell C3 is NOT blank then the result is True.

I know there are differences in cells being empty of all data and being blank by way of ="". In this case the cells will actually be empty (no data, numbers, formulas, etc).

Any ideas for accomplishing this? (via formula is preferred but I could go VBA if needed)

[kev_]

How about
for both to be blank:

Please Login or Register  to view this content.

and then add the second condition

Please Login or Register  to view this content.

[nerdshoveler]

kev_, that is a start but I need to look for any cell in column A. So assume it will need to include an array?

[kev_]

another way:

Please Login or Register  to view this content.

[kev_]

What exactly are you wanting?
If you copy the formula down it gives the correct answer for every row

Do you just want a one cell answer? If so what do you want the cell to tell you?

[nerdshoveler]

Yes, i want a one cell answer. I'm going to use it for conditional formatting of that cell.

[kev_]

So should the cell yield "TRUE" unless there is at least one row with a mismatch ie "blank in A with value in C" OR "value in A with blank in C"

[nerdshoveler]

I basically don't care if:
a) both are blank
b) both are populated
c) value in A with blank in C

I need to identify "blank in A with value in C". The result in this could be either "True" or "False". I can deal with either condition as long as it is the opposite result of the a), b), and c) examples I just mentioned.

[kev_]

An array formula is not required
Amend the range if data starts below A2 and/or extends below row 10,000

This formula returns FALSE if "Blank in A with value in C"

Please Login or Register  to view this content.

- CountIf counts the number of rows with both "a value in C" and "nothing in A"
- "=0" compares result of CountIf with 0
- if it matches, formula returns TRUE
- if it does not match, formula returns FALSE (ie if one or more row meets the condition)

[nerdshoveler]

kev_ , Thank you!!! That is working perfectly!!

[kev_]

Excellent!
Please mark the thread as Solved (thread tools, top of thread)