View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Peter is offline
external usenet poster
 
Posts: 349
Default Consolidating a Matching List

Assume I have a list of 30 rows with 5 fields each. A user can select whether
a row is a match or not a match. I have setup a test to catch the selected
matches, however since it checks row by row I have blanks (since the
"non-match" return is a blank).

I want to list the matching rows without any blank rows for the non-matching
rows.

Any ideas?