Filter out every fourth row

[hammer36]

Long story short...I have a very long list of contacts that I need to cut into thirds....this huge list has been sorted by importance (the top of the list are people that need to be contacted immediately) and there are three of us that need to start going through this list....is there a way to filter the data so that rows 1,4,7,10..etc. go to one list and rows 2,5,8,11,etc. go to a second list and rows 3,6,9,12,etc. go to a third list? This would save me alot of time and I would greatly appreciate any help I can get....since I have never used excel before I really don't know how to search on here using the correct verbage...Thanks

[Trebor76]

Hi there,

Hopefully the following five steps will help:

1. Ensure there are at least four tabs in your workbook - one that contains the raw data and three blank sheets.
2. Highlight (right click and drag) ⅓ of the transactions
3. From the Edit menu choose Copy
4. Click to the first (or next) blank sheet, select cell A1 and from the Edit menu choose Paste
5. Repeat steps 2 - 4 for the second and last thirds

HTH

Robert

[Bryan Hessey]

Long story short...I have a very long list of contacts that I need to cut into thirds....this huge list has been sorted by importance (the top of the list are people that need to be contacted immediately) and there are three of us that need to start going through this list....is there a way to filter the data so that rows 1,4,7,10..etc. go to one list and rows 2,5,8,11,etc. go to a second list and rows 3,6,9,12,etc. go to a third list? This would save me alot of time and I would greatly appreciate any help I can get....since I have never used excel before I really don't know how to search on here using the correct verbage...Thanks

Hi,

extra to Robert's guide, use a Helper column and in row 1 put

=MOD(ROW(),3)

and formula fill that for all of your data. (note, for 20,000 rows, Copy the cell (say Z1) and then in the Name box type Z1:Z20000 and press Enter to select the range, then Paste).

then Data Filter Autofilter and select each of 0, 1 & 2 in turn for one-third of your items.

Copy the complete rows shown to other sheets.

hth
---

[Paul]

hammer, please don't duplicate posts in the forum. Because of the duplicates, Robert and Bryan also spent time trying to assist when they could have been helping others in need.

http://www.excelforum.com/showthread.php?t=594675

(Although I do like Bryan's quick filtering method on this thread.)