Indexing Down Sorted Column to Next Unique Number

**longfisher** · 11-02-2007, 05:35 PM

I have a column of addresses and phone numbers, each in different adjacent columns, like below.

17605 Hidden Forest 281-384-3334
17607 Hidden Forest 281-374-2986
17607 Hidden Forest 281-374-2986
17607 Hidden Forest 832-661-2945
17607 Hidden Forest 281-374-5438

In an adjacent column I have just the addresses, like below.

17605 Hidden Forest
17607 Hidden Forest

And, I want to pull the phone numbers out of the first two columns when they match the address in the third and if they are unique display them next to the address in the third column, as below.

17605 Hidden Forest 281-384-3334
17607 Hidden Forest 281-374-2986 832-661-2945 281-374-5438

I can use VLOOKUP to find the first number easily. But I'm having trouble indexing down the column to find the subsequent numbers and display them in order.

Any help would be appreciated.

LongFisher

**Excelenator** · 11-02-2007, 05:42 PM

So do you want your rows to collapse once the phone number has been copied to the appropriate column? And would a VBA solution be acceptable?

**longfisher** · 11-02-2007, 06:31 PM

I'm no VBA wiz. And, I just don't have the time to learn it now.

Regarding the collapsing of the phone numbers. I need them in separate columns and without collapsing the rows.

Thanks,

LongFisher