sorting cells

[jfeil]

okay need help
have list of numbers(col 1) then another list of number (col 2) wit
initials attached in col3

need a way to organize them so they match up

so
BEFORE:

col1 col2 col 3
23 45 cd
45 12 cd
98 75 ag
56 84 cj
75
84
12

AFTER:

col1 col2 col3

12 12 cd
23
45 45 cd
56
75 75 ag
84 84 cj
9

 

[Dav]

Assuming that the entries in column 1 are unique (no duplicates)

I would sort the data in column 1

Copy the data from column2 and 3 else where

I may then sort although it is not necessary

Then use a vlookup for column 2 it is enclosed in the if statement to
avoid #N/A being returend

=IF(ISNA(VLOOKUP(a2,$G$2:$H$100,1,0)),"",VLOOKUP(E8,$G$2:$H$100,1,0))

Assuming the data to match is in cells g2:h100 adjust accordingly

Then for column 3

=IF(ISNA(VLOOKUP(a2,$G$2:$H$100,2,0)),"",VLOOKUP(E8,$G$2:$H$100,2,0))

Regards

Dav