Split value into new rows, based on other Columns

[Bill Szysz]

Check it out.

[Sagittariu5]

Thank you Ken

[Sagittariu5]

Thank you Ken and looking forward to you help and insight on the matter. Truly appreciative

[Bill Szysz]

Sagittarius5, can you tell me what is wrong with my proposal ? (post #11)

[Sagittariu5]

Hello Bill,

Apologies, replied using my phone and overlooked your reply (post #11) on the second page.

Thank you, I believe this solves my problem.
Please note I adjustment [Rental Fee]/20 -1 to Number.Round([Rental Fee]/20 -1,0), since wanted positive whole number value.

Kudos

Also how do I mark this thread as solved?