This is for accounting purpose
I have one single amount example 1,00,000
now I want excel to split this amount into multiple small amount but that
amount should split in 365 rows only and in the end total figure should exactly 1,00,000
I have tried =rand and =rand(between) but did not got the desire result