COUNTIF to compare 2 seperate columns of names both exact matches and similar matches

[Poolshark25]

Hi

I'm using COUNTIF to compare a list of names that is imported from the web (Column C) to my own list of names (Column A) and counting these for matches in (Column B).

I'm using COUNTIF to count when there are matches in 2 separate columns as below:

Column A Column C
Actress Actress

This returns a 1 when there is a duplicate in both tables which is what i want as i will then use advanced filtering to list the matches on a different part of my sheet, which i'm ok with.

The problem i have is that one of the columns is imported from the web and displays the names slightly different as below:

Column A Column C
Actress Actress (IRE)

I need COUNTIF to also return a count when there are close matches too as although these look slightly different in the 2 lists they are actually the same thing in bot lists.

Is there a way to get COUNTIF to also return a 1 for both exact matches and close matches?

Any help would be grateful,

Kind regards

Ernie

 

[FlexMind]

Could you be so kind to share some small Excel example?
It will help me to help you, I guess.

 

[Poolshark25]

Hi, thanks for offering to help me. My file is at work so I can send you the full file tomorrow if that's ok. I'm not sure I'm using the right method to achieve what I want to do here so it may well be that using countif and then advanced filtering won't work anyway and there might be a better method.

I have a table that I have imported from the Web of horses that are running tomorrow along with the meeting, time and price. These are in columns A-D. In column E I have a list of horses I follow each season.

I want to compare my list of horses I follow with the imported list of horses running tomorrow and if any of my horses are running to then list these in a new area of my sheet with horse name, meeting, time and price, as it is in the imported table from the Web format.

It sounds easy to do but I just can't figure it out or maybe I'm using the wrong method/functions etc.

I would be really grateful if I could send you my file, if you could please have a look and help if possible.

My initial thought when I started this was to use countif to return a 1 if the 2 lists compared have any duplicates. Then to use advanced filtering to extract and list any runners somewhere else on my sheet. I could then hide any columns/rows I don't want to see and just be left with a custom view Todays_Runners. Each day I would then just need to open my file and click on 'Refresh all' from the data tab to refresh and fetch the next days runners into the sheet and the rest would then be updated automatically with my new list of runners each day.

Sorry for the long message.

Please let me know if I can send you the file and I can do that in the morning.

Kind regards,

Ernie

 

[FlexMind]

Please let me know if I can send you the file and I can do that in the morning.

OK, I'll be waiting for the file.

 

[Poolshark25]

Hi FlexiMind

I can't seem to be able to find a option to attach the file. Can you advise how i do that please?

 

[Poolshark25]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Horse
[/TD]
[TD]Race
[/TD]
[TD]Day
[/TD]
[TD]Sky Bet
[/TD]
[TD]Horses 201 - 2019
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Columns A D Imported from web. column E is my list of horses. I want to compare my list to imported list and return any runners to another part of my sheet including column data A-D for each row when a horse match is found. Hope that makes sense. Similar to an advanced filter

 

[FlexMind]

Hi, I think you could use the file hosting services.

 

[Poolshark25]

Hi, Sorry i wouldn't even know where to start with that service. Had a quick look and i'm baffled by it.
I sent you a message earlier today with a table on it. Did you get it?

 

[Poolshark25]

https://drive.google.com/open?id=1_d9mn5r1_0h3yxCFGQy73pqlAbXXkAFj

Try this

 

[FlexMind]

Hi, Sorry i wouldn't even know where to start with that service. Had a quick look and i'm baffled by it.
I sent you a message earlier today with a table on it. Did you get it?

No, I haven't got any messages.
But anyway I see the file from your previous post.
I'll look at it in the evening.