Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combinin Columns
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Averaging columns | New Users to Excel | |||
interchange columns with rows | Excel Discussion (Misc queries) |