How do you match one column's numbers with the 2nd column?

L

lnsykalski

How do you math one column's numbers with the 2nd column?

Like if you had:

1 2
2 3
3 6
4
5
6
7

... and you wanted it sorted like so
2 2
3 3
6 6
1
4
5
7

Any idea how to do that?

Thanks,
Lee:confused
 
A

Ardus Petus

Assuming your data are in columns A and B

insert a staging column before column B, with following formula:
=IF(ISNA(MATCH(A1,C:C,0)),"",MATCH(A1,C:C,0))

Select columns A:B
Data>Sort by Column B (ascending)

HTH
 
Top