How odd! The second question today about this formula

=IF(COLUMN()-COLUMN(NoBlanksRange)+1COLUMNS(BlanksRange)-COUNTBLANK(BlanksR
ange),"",
INDIRECT(ADDRESS(ROW(BlanksRange),SMALL((IF(Blanks Range<"",COLUMN(BlanksRan
ge),COLUMN()+COLUMNS(BlanksRange))),COLUMN()-COLUMN(NoBlanksRange)+1),ROW(Bl
anksRanges),4)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"grime" wrote in
message ...

I need help converting Pearson's array formula from a list in a column
to a list in a row:

http://www.cpearson.com/excel/noblanks.htm

=IF(ROW()-ROW(NoBlanksRange)+1ROWS(BlanksRange)-
COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL(
(IF(BlanksRange<"",ROW(BlanksRange),ROW()+ROWS(Bl anksRange))),
ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))

Thanks in advance!


--
grime
------------------------------------------------------------------------
grime's Profile:
http://www.excelforum.com/member.php...o&userid=19227
View this thread: http://www.excelforum.com/showthread...hreadid=481884