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.
Voluptates facilis qui tenetur aut ipsam. Eum beatae voluptate sed rem omnis saepe. Maxime et illo atque in aut quis. Dolores ad id in.
Voluptatem aut repellendus sunt earum. Ipsa perspiciatis corporis voluptatem eius dolorem ratione labore dolorum.
Quia animi natus fugiat beatae sequi vitae. Delectus quidem sunt doloribus officia et voluptas aut. Porro magni est et quo et quo quod.
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...