View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com
 
Posts: n/a
Default Return Single Row of Numeric Data to Single Column

Hi Biff,

That was brilliant, thank you.

=INDEX(C$13:DV$13,ROWS($1:1)*2)

Copy down as needed.


Cheers,
Sam

Biff wrote:
Hi!

Try this:

=INDEX(C$13:DV$13,ROWS($1:1)*2)

Copy down as needed.

Biff

Hi All,

[quoted text clipped - 14 lines]
Thanks
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1