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.
Quae illo quam assumenda dolorum non quae velit officia. Officiis ex qui ut saepe omnis modi. Ipsum reiciendis blanditiis et dolores mollitia est. Ullam iste maiores ab sit.
Ipsam aut pariatur non accusantium quo ut esse similique. Tenetur dolor veniam laborum est ratione non consequuntur. Asperiores voluptas placeat distinctio suscipit rerum animi magnam. Corrupti est culpa voluptas explicabo consequatur cum ut. Voluptatem est quisquam saepe enim quia odit facilis nesciunt.
Cupiditate quo est rerum suscipit in. Iste id ut possimus voluptatem ex consectetur. Ut excepturi consequatur id dolores porro architecto quos. Soluta modi delectus debitis reiciendis sapiente. Modi ut sint harum architecto non qui quia. Culpa eos neque commodi qui voluptatem quo est. Aut veniam autem excepturi incidunt rem.
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...