pulling select names by codes?

[Mare]

Hello,
I have a list of 7000 names, addresses etc like below. I would like to
pull all the people with their correct address and names with the same code
number in H column. How would I do this

Thanks Mare


A B C D
E F G H

(code)
4006 TUCKER MARY L PO BOX 6324 LKPORT NH 03247-6324 0
26709 THYNG JOANNA M PO BOX 679 ASHLAND ME 4732 0
16643 MELVIN LEE R 2405 BOSTON POST RD GUILFORD CT 6437 0
17232 CUCCARO MEGAN P 53 MARSHALL RD MERIDEN CT 6450 0
19400 ZURAD JOHN T 608 KAYSER AVE PINEHL NJ 8021 0
16091 STOKES JAMES A 333 BOWERY KENTON HALL RM 326 NEW YORK NY 10003 0
21174 RAWLINGS JEAN E 35 SOLOMON ST BELLE VERNON PA 15012 2
22055 SMITH LORI L 418 LTL BLUE RD GEORGETWN PA 15043 1
15102 PINDILLI DIANE L 3396 ST RT 18 HOOKSTWN PA 15050 1
12340 RICHARDSON LYNDA S 204 S 8TH ST W NEWTON PA 15089 0
24661 AUSTIN MARSHA L 810 KRIS DR APT 154 PITTSPRG PA 15108 0
25978 SEFZIK BONNIE J 330 ABBEYVL RD APT D PITTSBURGH PA 15228 0
24688 NEMURAS MARTHA J 1980 W CHESTNUT WASHINGTON PA 15301 4
25897 O'BRIEN GLORIA A 1280 BRUCE ST WASHINGTON PA 15301 4
7107 BUKOVINSKY MARY E BOX 225 AVELLA PA 15312 4
5729 BIERER MARLENE OMA BOX 45 AUGUSTA AVE BOBTWN PA 15315 3
15995 JAVOSKY JANET L PO BOX 446 BOBTWN PA 15315 3
24926 LOCKHART ROCKELLE L PO BOX 77 BOBTWN PA 15315 3
20005 NOVAK LISA R PO BOX 224 BOBTWN PA 15315-0224 3

 

[Earl Kiosterud]

Mare,

Sort the table on column H. If you want all names with a 0 code
alphabetically ordered, etc., first sort on the name column, then column H.
We call that "code then name" order, or "name within code."