Excel help with formula
I want to create time weighted revenue.
I have one table of monthly data with 2 columns. One column has a date including the hour, and the other has associated production values. I have another table with a few years' data, with 2 columns. One column has a date including the hour, and associated prices. One table, because it's monthly data, is shorter than the other table.
I want to create a function in the prices table that goes through each value in the date column and says, where this date is found in the production table, multiple the production and prices.
I have already removed the years from the dates so that it is easier to match columns.
Below is an example.
Any guidance is helpful.
ChatGPT brother.
I've tried but perhaps I'm not explaining my prompt correctly.
Aut aliquam alias tenetur nam. Optio ducimus qui sunt qui enim. Hic corporis quasi quasi rem modi.
Enim corporis laudantium sit laboriosam modi. Perferendis consequuntur animi rerum aspernatur. Placeat reprehenderit unde sed eius sed magni repellendus unde. Dolor facilis quia qui est rerum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...