Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Van Van is offline
external usenet poster
 
Posts: 8
Default Excel Formula to copy every nth row

Hi,
I have seen a few post regarding similar question but, I cannot seem to get
one that is fitting. Im looking for a formula that will copy every nth row
from a different spreadsheet into a current spreadsheet. It is all text but
keeps returning a "0" result.
Any ideas and help would be greatly appreciated.
Thanks,
Van
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default Excel Formula to copy every nth row

Hi,

Lets' say that you data is arranged in the following format in range A1:B7

Name Age
A 1
S 2
D 3
F 4
G 5
H 6

In A9, type "condition" (without the quotes). In A10, enter the following
formula =MOD(ROW(A2:A7),2)=1 . Now perform the following steps:

1. Highlight range A1:B7;
2. Go to Data Filter Advanced Filter
3. Select copy to another location
4. In list range give the reference as A1:B7
5. In criteria range, give the reference as A9:A10
6. In copy to, give the reference of any blank cell

Now click on OK. This will copy all the alternate rows to the specified
location.

Hope this helps

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Van" wrote in message
...
Hi,
I have seen a few post regarding similar question but, I cannot seem to
get
one that is fitting. Im looking for a formula that will copy every nth
row
from a different spreadsheet into a current spreadsheet. It is all text
but
keeps returning a "0" result.
Any ideas and help would be greatly appreciated.
Thanks,
Van


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula to copy/paste formula needed please. colwyn Excel Discussion (Misc queries) 4 October 22nd 08 11:27 PM
Copy formula in excel shee Excel Discussion (Misc queries) 4 March 28th 07 02:45 AM
Copy formula in excel shee Excel Discussion (Misc queries) 0 March 28th 07 12:00 AM
Copy/Paste how to avoid the copy of formula cells w/o calc values Dennis Excel Discussion (Misc queries) 10 March 2nd 06 11:47 PM
Excel Formula Copy Jennifer Excel Discussion (Misc queries) 2 January 5th 06 06:02 PM


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"