Emergency Excel Help Needed

primesuspectprimesuspect Beepin n' BoopinDetroit, MI Icrontian
edited January 2007 in Hardware
AS FAST AS POSSIBLE

I need to know (or have someone do it for me) how to take a file with 12000 rows of data in excel, and pull every 8th record out and put those into a new file.

So, the data is like this:

01: FK91-8818-9248-8338 3YLB3ZYBA7JENY7A
02: FK91-0899-9258-4345 YJE3LPL3JB8PHPP3
03: FK91-2870-9258-1452 8AJWZEB7BPP3N3LB
04: FK91-3851-9258-8459 ETANHPEYH8EZPL7N
05: FK91-5832-9258-5466 P78PY7EALHYBNT3W
06: FK91-7813-9258-2473 WETT3HA3LHNEPBB8
07: FK91-8894-9258-8480 KKLWP38NHKTHLWPY
08: FK91-0875-9268-5487 3JENK8EY7APKELEL
09: FK91-2856-9268-2494 NWYETBZPBLBZPBA3
10: FK91-3847-9268-9401 KZ378N3EWT7TYLTN
11: FK91-5828-9268-6408 B8K837PNZNBZPLJY
12: FK91-7809-9268-3415 ANWAZEJYT8W3PWBY
13: FK91-8880-9268-9522 YTZKZYAHBJHKAZNY
14: FK91-0861-9278-6529 A8JHET8E788A7LPH
15: FK91-2842-9278-3536 PZJYALNHJ8H77W7B
16: FK91-4823-9278-0543 HZAAJAEHJKAT88PJ

and so on.

I would need a new file with:
08: FK91-0875-9268-5487 3JENK8EY7APKELEL
16: FK91-4823-9278-0543 HZAAJAEHJKAT88PJ
24: such and such and so on.

PLEASE HELP!

Comments

  • primesuspectprimesuspect Beepin n' Boopin Detroit, MI Icrontian
    edited January 2007
    Got around it by using a simple trick suggested by a friend:

    Add a new column, manually type in the numbers 1 through 8 (one number per column), copy those eight rows, and then highlight the entire column, paste it in. It will repeat 1-8 throughout the entire document. Then, sort by that column, and extract all the "8"s, finito.
This discussion has been closed.