sorting columns of data

[Lisa Hetherington]

I have about 100 addresses in column A that correspnd to 100 addresses of
960 in column B but they aren't in the same rows right now. And some rows
in column C have entries.



B A w
C B
F C w
M D

and so on

I need to preserve columns B & C, I just need to add and sort the 100 or so
addresses from column A into the corresponding row


A w
B B
C C
D w
E
F F
G
H
I
J
K
L
M M

and so on

I think I should be sorting by multiple columns but I'm not sure how. Any
suggestions would be appreciated!

....Lisa

 

[KC Rippstein]

Copy column A over to column E, then sort that list in column E (leaving
your header at the top).
In F2 type =VLOOKUP(B2,E:E,1,FALSE) and copy that down as far as you need.
Then in A2 type =IF(F2=NA(),"",F2) and copy down.
Highlight column A and copy it, then Edit->Paste Special->Values.
Delete columns E and F.

- KC

 

[Lisa Hetherington]

Thanks KC!

....Lisa

Copy column A over to column E, then sort that list in column E (leaving
your header at the top).
In F2 type =VLOOKUP(B2,E:E,1,FALSE) and copy that down as far as you need.
Then in A2 type =IF(F2=NA(),"",F2) and copy down.
Highlight column A and copy it, then Edit->Paste Special->Values.
Delete columns E and F.

- KC