Here's another way...

Assuming that the results are to be returned in Row 25, starting at D25,
leave C25 empty, then try the following formula which needs to be
confirmed with CONTROL+SHIFT+ENTER...

=INDEX($D3:$BZ3,MATCH(0,IF(COUNTIF($D6:$BZ6,$D3:$B Z3)=0,IF(COUNTIF($D16:$
BZ16,$D3:$BZ3)=0,COUNTIF($C25:C25,$D3:$BZ3))),0))

Note that Conditional Formatting can be used to hide #N/A error values.

Hope this helps!

In article <63490f00ad995@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi All,

How can I Return Numeric Results across a single Row in consecutive cells -
no blank / empty cells?

I am using the Formula below to Return the Results of Numeric Labels that DO
NOT exist in the two Row arrays $D$6:$BZ$6, $D$16:$BZ$16:

=IF(AND(D3<$D$6:$BZ$6,D3<$D$16:$BZ$16),D3,"") - Array entered.

The Numeric Labels in the Row arrays are in sequential ascending order.

When the Results are Returned I get blank cells in between the Results (for
the Numeric Labels that EXist in the above two Row arrays - $D$6:$BZ$6, $D$16:
$BZ$16):

1 2 blank blank 5 blank blank blank 9 blank 11 etc.

How can I Return the Results without blank cells in between? Filling each
cell consecutively - like this:
1 2 5 9 11

Thanks
Sam