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
|