Thread: How do I increment from cell to cell by 10?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Danny Danny is offline
external usenet poster
  
Posts: 148
Default How do I increment from cell to cell by 10?
I have an excel spreadsheet that has 50,000 rows and all info ins in one
column. I would like to consolidate it to 10,000. When I go to B1 and put in
=average(A1:A2500) it averages fine. However when copying this code and
pasting it in B2 the formula turns into =average(A2:A2501). I would like to
have these numbers increment by 10 instead of 1. Is this possible? Please let
me know!
Reply With QuoteReply With Quote