View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default In need of a formula

ups sorry it vas the dennish way

=INDIRECT("A"&COLUMN()-1)

by the way i think not that 1 do the trick for u after i read
ur question again :-(

is ur data allways 4 rows data then a emty 1 then 4 rows data and so on ?