help with excel

NBVC · #1 06-01-2017, 12:54 PM

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.

adrianoromano · #2 06-02-2017, 07:00 AM

Quote:

Originally Posted by NBVC

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.

Thank you so much

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data?	Hoser	Word	1	03-17-2017 03:47 PM
Embeding Excel Docs in Word - Receiving Memory Error Message if Excel is open	kdash	Word	0	05-06-2015 09:38 AM
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet?	ADubin	Excel Programming	3	02-08-2015 04:57 AM
[Excel 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM