Recommender Systems in Visual Basic for Applications

Waimea

Active Member
Joined
Jun 30, 2018
Messages
372
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 COSINE SIMILARITY and in this thread, https://www.mrexcel.com/forum/excel-questions/1071732-cosine-similarity.html user joeu2004 helped me with the code.

How can I use the code for COSINE SIMILARITY on my spreadsheet?
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,108,727
Messages
5,524,478
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top