Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel to pull out every tenth row into a separate sheet? How?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel to pull out every tenth row into a separate sheet? How?
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 On Mon, 25 Jun 2007 14:16:02 -0700, Eileen wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel to pull out every tenth row into a separate sheet? How?
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 "Eileen" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I pull a date from a separate worksheet using the IF functi | Excel Worksheet Functions | |||
Can taxes be totalled on separate sheet when using Excel invoices | Excel Worksheet Functions | |||
Can a worksheet pull from a specific cell value in a separate wrks | Excel Worksheet Functions | |||
I need a daily sales sheet to pull from monthly figures sheet | Excel Worksheet Functions | |||
How do I set up a formula in excel that is the tenth root of 7 ve. | Excel Worksheet Functions |