| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two different columns - looking for similar data
Hi,
You can send me the file at . -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Cheimbig" wrote in message ... Can I just send one of you the file --- neither of these worked for me - so I am clearly doing something wrong. -- Carla Heimbigner "Ashish Mathur" wrote: Hi, You can use advanced filters as well. 1. Assume you have 2 lists as follows. List 1 (including heading) is in range C4:C13 and List 2 (including heading) is in range D4:D9 List 1 List 2 A A S T D Y f H g G H J L M 2. Type condition in C16; 3. Type =COUNTIF($C$5:$C$13,D5)=1 in C17 4. Type List 2 in cell C21 5. Now go to Data Advanced Filter and click "Copy to another location" 6. In the list range, select C4:D13; 7. In the criteria range, select C16:C17 8. In the Copy to box, please refer cell C21 9. Now click on OK Please not that this in not a dynamic solution. If any entry in List 1 or List 2 changes, you will have to rerun the advanced filter. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Cheimbig" wrote in message ... I have 2 columns with names I want to have a 3rd column with only the names that match Is there a function for doing this -- Carla Heimbigner |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing data in two sheets with similar values | Excel Worksheet Functions | |||
| Comparing similar data on different sheet tabs | Excel Discussion (Misc queries) | |||
| comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) | |||
| Finding similar data or numbers in two columns | New Users to Excel | |||
| Comparing data in two similar worksheets | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
