Hi
not completely sure but try:
- insert a new column C (column 3)
- in C1 enter
=IF(COUNTIF($D$1:$D$100,A1),VLOOKUP(A1,$D$1:$E$100 ,2,0),"")
and copy this down
Afterwards copy column C and insert it again with 'Edit - Paste
Special - values' to remove the formulas
--
Regards
Frank Kabel
Frankfurt, Germany
"Susana Conklin via OfficeKB.com" schrieb im
Newsbeitrag ...
I have an entire database of info that looks like:
colum one =99213 column two= 10.00 column three= 99213 column four-
11.00;
how do I make a table that shows:
column one= 99213 coulmn to= 10.00 column three= 11.00
Note that column three has more information in it so the rows do not
excaly match across for all..
help!
--
Message posted via http://www.officekb.com