Jul 08 2022 11:32 AM
Hi I have an excel sheet in which money is written but I want that whenever I total money, it should give me a blank row as soon as it is 1000 in each total like the total of the data I have is 5000. If you are getting total of money, then as soon as the total is 1000, then insert a blank row and write its total, such a total will be 5 blank rows, and in that blank row the total of the above amount which will be either 1000 or less.
Please help as soon as possible
Jul 08 2022 12:44 PM
@Manish_Ojha so I did a couple of options because I wasn't sure what you need exactly:
each of the columns E:I are based on the values in A and column C is just for reference.
columns E&F use array formulas while H&I use old style formulas that you copy/fill down
in each case I show value if the cumulative total crosses the thousands mark. I think this is what you wanted. If not please explain a little better.