Split the Amount in to under value

[Patnaik]

Hii Team

Glad to see You again after long gap, hope my team and friends all are well and enjoying their life with full of joy

Ok coming to my problem, i need one support from my team that is i want to split the amount into under value

wait i am explaining how the result to be

Say i have an amount in the date 08-06-2024 and Rs. 150000.00 now i want to split the amount to under value so under value is Rs. 10000.00

then how many entries it will take for the Under Value is 150000/10000 = 15

1. 08-06-2024 10000.00
2. 08-06-2024 10000.00
3. 08-06-2024 10000.00

so on

But there is one problem that is i don't want the amount to be same for the split and the total amount to be match

hope you understand my requirement

i have large amount of list and i want that in at a time

for your support i have attached a sample excel file

Your Help is highly appreciate for me

Thanking You

[AliGW]

Administrative Note:

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

[Patnaik]

Thanks for Your Valuable Replay

well i am using Excel 2007 and windows 10

Thanking you

[AliGW]

Please remove 2003 from your profile. Thanks.

Also, you are likely to get asked again, as 2007 is a very old version - I suggest you start threads by stating thet you are still using Excel 2007.

[Patnaik]

Thank You

as per your instruction i have changed the version in my profile from 2003 to 2007

actually i feel friendly with the version of 2007

[AliGW]

I'm confused. You have now added 2010 - please only state the version that you want to use (2007) in the profile.

[Patnaik]

Completed

Sorry for Confusing You

Thank you

[Patnaik]

Hii, Good Afternoon