View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Carim[_2_] Carim[_2_] is offline
external usenet poster
 
Posts: 97
Default referencing the data in a cell

Hi,

=OFFSET($A$1,(ROW()-1)*5,0)

HTH