A function that verifies pair matches

T

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
 
T

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.
 
V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top