Formula for distributing title hours in different months.

Zee996

New Member
Joined
Nov 30, 2021
Messages
32
Office Version
  1. 365
Platform
  1. Windows
Hello everyone,

I need help in creating a formula. I would like the formula to distribute the "title hours" from different rows across months, starting from June-23 to January-24.

I have four columns, and the data is extensive(Below is the Small snapshot). Each Level and Function have around 49-50 titles underneath.

Is there a way to automate the implementation of months, or is it only possible manually?

I would be grateful if anyone could provide their help.

LevelFunction TitleTitle HourMonth(Need months to automatically populate in this column)
A1Production Excel training 1
A1ProductionPowerPoint 2
B1SalesCourse on Sale3
B1SalesSale Benefits1
B1SalesHappy Selling 1.5
C1TechAgile0.50
C1TechHTML2.67
C1TechSQL3.45
C1TechPython 6.89
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Perhaps you could manually fill in the expected results for the sample data above and post it again with any further written clarification?
 
Upvote 0

Forum statistics

Threads
1,215,869
Messages
6,127,415
Members
449,382
Latest member
DonnaRisso

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top