| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing common values in either different worksheets or columns
I would appreciate help with the following: Let's say I have two or three
worksheets. How do I find the common values in them. Say, for instance, if I have an aray of names in Worksheet 1 how can I find out which ones of those names in that array will be repeated in Worksheet 2 and Worksheet 3. Also, if I have three different columns each of different length, how can I find out which names in column 1 are common to columns 2 and 3? I would appreciate help here. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing common values in either different worksheets or columns
Excel 2007 Pivot Table.
Filter common items in multiple Tables. http://www.mediafire.com/file/wgwgwmmt2yw/05_06_09.xlsx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing worksheet values in two worksheets | Excel Worksheet Functions | |||
| combining excel worksheets with common columns | Excel Discussion (Misc queries) | |||
| comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
| Comparing columns from 2 different worksheets. | Excel Worksheet Functions | |||
| Comparing two columns in two different worksheets | Excel Worksheet Functions | |||
Linear Mode
