Thread: help with excel
View Single Post
 
Old 06-01-2017, 12:54 PM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try:

=INDEX(A:A,10*(ROWS($A$1:A1)-1)+10)

copied down.

You may need to adjust if you are not starting at A1.
Reply With Quote