Thread
:
A function that verifies pair matches
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
vezerid
Posts: n/a
A function that verifies pair matches
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
Reply With Quote