Can excel to pull out every tenth row into a separate sheet? How?

E

Eileen

I have a huge series of Surveying shots (P,N,E,Z,D) and I would liket o pull
every tenth shot out and into a separate sheet. Any advice?
 
G

Gord Dibben

Assuming shots are in Sheet1 Column A

=INDIRECT("SHeet1!A"&ROW()*10)

Entered in A1 of a new sheet.

Copy down as far as you wish.


Gord Dibben MS Excel MVP
 
B

Barb Reinhardt

I think I"d do this with a helper column, but I'm not sure what you mean by
Surveying Shots and how you identify every 10th shot. Do you keep track of
the codes P, N, E, z and D?

Let's assume your Surveying Shots are in column A and start in A3. Try
something like this

=MOD(COUNTIF(A$3:A3,A3),10)

Copy the value down to the end of the list of Surveying shots. Then use
autofilter to select the value of the helper column you want to use.

HTH,
Barb Reinhardt
 
Top