| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Merge
Hi,
I have two worksheets in the same book. Sheet 1 ID / Course / Description / Amount 01/PH 101 /Basic PR / $200 01/PH 102 /Inter PR / $50 02/GD 203 /Basic Gd / $150 03/L 301 /Travel / $250 03/SC 401 / Science /$100 etc... Sheet 2 ID /Base /Addition /Total 01 /$250 /$0 /$250 02 /$150 /$0 /$150 03 /$100 /$250 /$350 What I want to create is: ID / Course / Description / Amount /Base /Addition /Total 01/PH 101 /Basic PR / $200 /$250 /$0 /$250 01/PH 102 /Inter PR / $50 02/GD 203 /Basic Gd / $150 /$150 /$0 /$150 03/L 301 /Travel / $250 /$100 /$250 /$350 03/SC 401 / Science /$100 Please note the values in sheet 2 show up only once. Can I do this? How? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to merge from excel to word. New names won't merge | Excel Worksheet Functions | |||
| Merge option is not available. How to undo merge in this case? | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Merge =( formula should retain fraction type numbers after merge. | Excel Worksheet Functions | |||
| how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
Threaded Mode
