movies

Hi Guys, I need help. I want to use Web Query in my Excel Sheet to show the Gross Sales of the movies that I am looking for. Information about the movies are in columns A and B. Column A contains the title, column B has the year when the movie was released. Column C to E will displayed the...

Hi, I am looking at the following page: https://simeneide.github.io/recommendations/2017/05/27/CFexcel.html and I want to understand how to add more movies and more users to this existing spreadsheet. The goal is to make my own version of this spreadsheet with Microsoft Excel. All suggestions...

Hi everyone, i am sure that this question has been asked before and i will appologise now if that is so. i have searched for the answer and had no luck with achieving my objective. i will attempt to explain this and make it easy to understand, any help with this would be appreciated. Thanks in...

Hello everyone, I have two tables named Movies and Users. I want to create let's say something like a matrix of Movies and Users table by adding and multiplying a row from Users with another row from Movies. The SUMPRODUCT is an elegant method doing the calculation. The problem is I have to...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'; min-height: 14.0px}span.s1 {text-decoration: underline}span.Apple-tab-span {white-space:pre}</style>My original relational...