View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default 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