# similarity

1. ### Need Help with Calculating similarities using the Matching coefficient and Jaccard's coefficient methods in Excel

I have to use both methods listed in the "Topic" field using the observations below. I have searched and searched, but nothing is giving me clear instructions on how to do this. Obeservations Fever Cough Breathing difficulty Fatigue Headache Loss of taste Sore throat 1 1 0 1 1 0 1 1 2 1 1...
2. ### Merge duplicate and similar rows into new sheet

The initial part of my query is similar to some other posts (although I am not adept enough at VBA to modify the code as needed to suit my purposes), but because the second part goes beyond what I've been able to find already on the forum, I thought I'd post the whole question here. I'm working...
3. ### Index match or find the maximum matching value

Hi All, I am trying to design a formular, I have a list of products with its descriptions. Also I developed a function called similarity which determine two cells similartity %. So Now I have a list of new products and old products list with its functions. Is it possible in B15 and B16 to use...
4. ### Recommender Systems in Visual Basic for Applications

Hi, I am trying to create a recommender system in Excel by using VBA. I am using a spreadsheet I created by watching this video: https://www.youtube.com/watch?v=gOdLYa7GPQY&list=PLrwfR6PR5Z3g6nduXPW9W4sdokCFwZEeg&index=3 I am calculating correlation by using CORREL but I would like to use...
5. ### Cosine similarity

I am currently using CORREL and I would like to be able to calculate "cosine similarity". I have searched but not found anything on this message board. https://en.wikipedia.org/wiki/Cosine_similarity
6. ### Microsoft "Fuzzy Lookup" results

Using Excel 2010, and the Microsoft "Fuzzy Lookup" add in to compare a column out of 2 worksheets. First worksheet has around 48,000 rows (x 3 columns), second worksheet has around 23,000 rows (x 5 columns). The "Fuzzy Lookup" is comparing one column from each & returning a similarity between...
7. ### Help formula needed to find similarity

Hi guys I need help finding out which formula works best at find similarities between to rows. For example Row A1................... Row B2 8443..................... 1231 1554...
8. ### making two uinque list with "similarity" and "counting"

Mr.Excel Members with hello and regard i have Column A and B of this table. Column A code are commodity codes and column B are countries that import this commodities (my data are in 325678 rows and i am working with excel 2007): <table style="border-collapse: collapse; width: 303pt;"...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back