sorting columns of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisa Hetherington - 20 Feb 2007 18:17 GMT

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

Reply to this Message

KC Rippstein - 20 Feb 2007 22:40 GMT

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

>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
[quoted text clipped - 30 lines]
>
> ...Lisa

Reply to this Message

Lisa Hetherington - 21 Feb 2007 03:42 GMT

Thanks KC!

...Lisa

> Copy column A over to column E, then sort that list in column E (leaving
> your header at the top).
[quoted text clipped - 39 lines]
>>
>> ...Lisa

Reply to this Message