| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two sheets and combine into one
I have two spread sheets and I would like to use a common column between the
two to create a combination / compare new sheet. This sheet would use the common column as the reference column but also compare the information in 2 other common columns Thanks -- Walt Moeller |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare two sheets and combine into one
Some commonly used functions that you can learn about in the XL help file to
get you started would be MATCH, VLOOKUP, or EXACT -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Walt Moeller" wrote: I have two spread sheets and I would like to use a common column between the two to create a combination / compare new sheet. This sheet would use the common column as the reference column but also compare the information in 2 other common columns Thanks -- Walt Moeller |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare two sheets and combine into one
Like Luke have mentioned, there's a couple of functions that you can use from
the Help file. I suggest that you post a sample of your data in 2 sheets and what is the result you are looking for so that we can of assistance. -- If this posting was helpful, please click on the Yes button Thank You cheers, "Walt Moeller" wrote: I have two spread sheets and I would like to use a common column between the two to create a combination / compare new sheet. This sheet would use the common column as the reference column but also compare the information in 2 other common columns Thanks -- Walt Moeller |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare to two sheets in one excel file to evaluate and combine whereidentical. | Excel Worksheet Functions | |||
| Compare then combine data, then mailmerge with Word | Excel Discussion (Misc queries) | |||
| compare and combine data with in one workbook | Excel Worksheet Functions | |||
| How do I activate the xls feature to combine and compare workbooks | Setting up and Configuration of Excel | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
Hybrid Mode
