Thank you for your help. I wasn't able to figure out exactly what you ment
by Eliminate blanks with IF(ISERROR(...

but I eventually got it to work by creating a intermediate worksheet between
the result worksheet and the origional.
intermediate worksheet: I gathered the data fields and used the first
column as an index. There were blank lines in this worksheet.
=IF('All Articles'!$H2 = $A$2, MAX(A$3:$A3)+1,"")
=IF('All Articles'!$H2 = $A$2,'All Articles'!N2,"") etc.
Then fill down.

result worksheet: I used lookup on each index number to remove the blank
lines.
=IF(MAX(Separate!$A$2:Separate!$A$301)=MAX($A$1:$A 1),"",LOOKUP((MAX($A$1:$A1)+1),Separate!$A$3:$A$30 0,Separate!A$3:Separate!A$300))
=IF(MAX(Separate!$A$2:Separate!$A$301)=MAX($A$1:$A 1),"",LOOKUP((MAX($A$1:$A1)+1),Separate!$A$3:$A$30 0,Separate!B$3:Separate!B$300)) etc.
Then fill down.

Thanks for the help!

"Ziggy" wrote:

Sheri,

I insert a test colum into the data table that indentifies whether or
not that data row contains the criteria. (Test column is A, Data
Column is D) . A1 = Required data extraction (CNT) I also add a
counter.

If(D5 = $A$1, Max($A2:A4)+1,"")

This puts a numbering sequence into column A that meets all of the
criteria.

On the Result sheet you have numbers 1.... XXX and either INDEX/MATCH
or VLOOKUP to pull in the results. Eliminate blanks with
IF(ISERROR(...

There are probably better ways but this is my way.

Hope it helps.

.