Thread: Trying to move a number in every 2nd column into a new worksheet into one colum, how would u do that? thanks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Trying to move a number in every 2nd column into a new worksheet into one colum, how would u do that? thanks
Hi!

Numbers in Sheet2, A1:J1

=INDEX(Sheet2!A$1:J$1,ROWS($1:1)*2-1)

Copy down until you get a #REF! error.

Biff

"dodat" wrote in message
. ..
thanks


Reply With QuoteReply With Quote