Naming ranges

[Shawn]

I imported a txt file into Excel. Each range includes an
account number in column A, an address in column B, etc.
What I need to do is find a SIMPLE was to name the
ranges. Each account number only takes 1 row, but each
address takes at least 4. I need to create a report that
will show the account number and address that relates to
that account number.

Any help would be appreciated. Thanks.

 

[Don Guillett]

example?

 

[Guest]

ACCOUNT NUMBER ACCOUNT REGISTRATION
PAYEE INFORMATION FUNDID NET WIRE
AMT SOURCE ID
-------------- ------------------------------------------
---------------------------------------- ------ ----------
---- ---------
15000XXXX John Doe Bank of
NYC SASPX 0.00
040507-
W278N1125 Woodside Dr
US
Clearing
0022-
Waukesha WI 53188
FFC:Marie Doe
00033

A/c:716-xxxxx


COD : 430

ABA : 021000018
05/05/04 BIN : FD3

A/N : 8661169975
C OPR : DPE