Thread: Copying a column list from one sheet to another and repeating???
View Single Post
  #3  
Old April 7th, 2009, 06:23 PM posted to microsoft.public.excel.worksheet.functions
klswvu[_2_]
external usenet poster
  
Posts: 27
Default Copying a column list from one sheet to another and repeating?
=OFFSET(Sheet1!$A$1,((MOD(COLUMN(),(COUNTA(Sheet1! $A:$A)))=0)*6)+(MOD(COLUMN(),(COUNTA(Sheet1!$A:$A) )))-1,0)

Better... eliminates the IF

"klswvu" wrote:

=OFFSET(Sheet1!$A$1,IF((MOD(COLUMN(),$A$1)=0),(COU NTA(Sheet1!$A:$A)-1),((MOD(COLUMN(),$A$1))-1)),0)