Use this array formula
=IF(ISERROR(SMALL(IF((ISNUMBER(MATCH(D3:Z3,$D$6:$Z $6,0)))+(ISNUMBER(MATCH(D3
:Z3,$D$16:$Z$16,0))),COLUMN($D$3:$Z$3)-MIN(COLUMN($D$3:$Z$3))+1,""),TRANSPOS
E(ROW($A1:$A20)))),"",
INDEX(D3:Z3,1,SMALL(IF((ISNUMBER(MATCH(D3:Z3,$D$6: $Z$6,0)))+(ISNUMBER(MATCH(
D3:Z3,$D$16:$Z$16,0))),COLUMN($D$3:$Z$3)-MIN(COLUMN($D$3:$Z$3))+1,""),TRANSP
OSE(ROW($A1:$A20)))))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:63490f00ad995@uwe...
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
--
Message posted via http://www.officekb.com