View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBW JBW is offline
external usenet poster
 
Posts: 42
Default how do you select every 8th cell

I want to grab the data from cells A2/A10/A18 etc
I thought if I did the first few and then selected them all and copied that
excel would get the idea and grab every 8th one, but it doesn't
Is there a formala that can say get cell that is previous one plus 8 rows?