View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Incremental Numbering whitin a formula

=OFFSET(Sheet3!$A$2,(ROW()-2)*3,)


"The Ron" wrote:

I need to exctract data from another sheet but I need to do it for every
third cell.

My formula so far cell A2: =Sheet3!A2
cell A3: =Sheet3!A5
cell A4: =Sheet3!A8

etc.

How can I copy this down with the cells as it's not copying down correctly
at the moment?