months brokendown by 12 months

H

Hank

Hello, I need some help to breakdown a total months to months in a year, such
as

total 32 months will be broken down by 12month 12month and 8month
total 63 months will be broken down by 12month 12 month 12 month 12 month
12 month and 3 month.

Is there any function in excel can do that??

Thanks a lot
Hank
 
J

Jacob Skaria

Do you mean

A1 = 63
In B1
=REPT("12month ",INT(A1/12)) & "and " & MOD(A1,12) & "months"

If this post helps click Yes
 
J

Jacob Skaria

'If you mean only the numerics in a cell then try the below

=REPT("12, ",INT(A1/12)) & MOD(A1,12)

'If you are looking to have the numerics in separate cells try the below
=IF(COLUMN(A1)<=INT($A1/12),12,IF(COLUMN(A1)=INT($A1/12)+1,MOD($A1,12),""))
and copy to the right as required

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

breakdown months 3
Pivot Table: Totals for "Last 12 months" and "Preceding 12 months" 3
Sorting in a Cross Tab Query 2
% of total 5
About calculate months between two date (date function) 2
Reference Formula Help 1
pivot table rolling 12 month filter? 1
Convert Age to Months 3

Top