Hi,

I have a file with a lot of word lists, different sizes. I would like to know if it's possible to find overlaps between these lists automatically.

Eg.

List A: lemon apple salad

List B: salad banana strawberry

List C: banana

....

I want to know if I there is an automatic way of signing this overlaps, or more specifically say how much overlap % there is between each of the lists.

Comebody can help?

Thank you in advance

Do you need the word/value in column A to match the same row in column B? i.e.

apple banana apple banana apple salad salad salad bananaIs apple in column A matched only to Column C, since it is not in the same row in column B?

I'm not exactly sure how to compare between the columns, but I know it's possible (try the VLOOKUP function).

I was going to recommend the "COUNTIF" function, but that would only help if you were looking for matches for a single word/value. If you were needing every possible word to be compared in the column, that might be too cumbersome.

Depending on how many different names you are looking for, you could do a separate COUNTIF function for every name. Take each count total for every name, divide by total, multiply by 100, and you have a %.

I did not interpret your post the same way that jdfry7did,

so could you please post some of your data with what it looks like before

and what you expect after.

READ this how to before posting your data:http://www.computing.net/howtos/sho...

MIKE

Ask Your Question

Weekly Poll