sorting cells
 

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

need a way to organize them so they match up

so
BEFO

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
98


--
jfeil
------------------------------------------------------------------------
jfeil's Profile: http://www.excelforum.com/member.php...o&userid=31095
View this thread: http://www.excelforum.com/showthread...hreadid=507647

sorting cells
 

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(E 8,$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(E 8,$G$2:$H$100,2,0))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=507647