A function that verifies pair matches

[Tetsuya Oguma]

Hi all,

I need a one simlpe function to return true if all the pairs are entered
correctly in both Column A and B and false if ANY of the pairs misses an
entry in either Column A or B. To illustrate:

(True)
A B
1 ABC 100
2 DEF 50
3 GHI 10

(False)
A B
1 ABC 100
2 DEF
3 10

Something along the line of {=SUM(A1:A3, B1:B3)}???

Thanks in advance

 

[Biff]

Hi!

Try this:

=SUMPRODUCT(--(A1:A3<>""),--(B1:B3<>""))=ROWS(A1:A3)

This would also return FALSE:

A B
1 ABC 100
2
3 GHI 10

Biff

 

[Tetsuya Oguma]

Hi BIff,

Thank you so much for this and my previous post!

If I want to still have a function returning True in the following
situation, what function should I write?

Sorry for complicating the issue, but that will be THE ultimate solution to
my problem!

Thanks again.

 

[vezerid]

Tetsuya,
try this:
=SUMPRODUCT(MOD((A1:A3<>"")+(B1:B3<>""),2))=0

This formula will return true if, in your range, all rows are either
completely filled or completely empty.

Does this help?

Kostis Vezerides

 

[Tetsuya Oguma]

Does this help?
You are LEGENDARY, mate!