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.
Et labore eligendi eaque rerum et repudiandae omnis nostrum. Nam consectetur quaerat excepturi vel.
Odit qui esse quia. Quasi impedit eveniet provident qui rerum molestias. Consequatur quo error consequuntur nulla quidem laborum et. Est cum ipsam consequatur debitis provident asperiores.
Consequatur sunt quia repudiandae iure asperiores hic. Eius beatae rerum amet et id reprehenderit. Sunt dolor recusandae et dolores repellendus quae amet itaque.
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...