Formula for distributing title hours in different months.

[Zee996]

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.

Level	Function	Title	Title Hour	Month(Need months to automatically populate in this column)
A1	Production	Excel training	1
A1	Production	PowerPoint	2
B1	Sales	Course on Sale	3
B1	Sales	Sale Benefits	1
B1	Sales	Happy Selling	1.5
C1	Tech	Agile	0.50
C1	Tech	HTML	2.67
C1	Tech	SQL	3.45
C1	Tech	Python	6.89

 

[Peter_SSs]

Perhaps you could manually fill in the expected results for the sample data above and post it again with any further written clarification?