Emergency Excel Help Needed
primesuspect
Beepin n' BoopinDetroit, MI Icrontian
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!
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!
0
This discussion has been closed.
Comments
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.