| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
comparing columns
I have several work sheets in which data is on both worksheets, I want to
compare this worksheets by a specific column and show only those that match so that I may place the results in a new column. does anyone know how to do that. |
|
#2
|
|||
|
|||
|
Marc -
You may want to read what the help files say about filtering data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Marc wrote: I have several work sheets in which data is on both worksheets, I want to compare this worksheets by a specific column and show only those that match so that I may place the results in a new column. does anyone know how to do that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Columns and Counting | Excel Discussion (Misc queries) | |||
| Comparing Data in 2 columns | Excel Worksheet Functions | |||
| Comparing data in two columns and highlighting the data | Excel Worksheet Functions | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
| Comparing Data in two columns | Excel Worksheet Functions | |||
Linear Mode
