similarity

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...

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...

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...

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...

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

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...

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...

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;"...