Expecting the Value in Column

Question

Hi All,

I have below blue table after calculating the difference coming (.02) in green box and expecting it automatically adjust with h column as basis of first invoice of every invoice number and give the figure in column J as result needed and different should be zero as showing in yellow box.

Please refer to the attached excel file as well. Please advise the WF

Thanks,

Rajeev

Book5.xlsx

Rhaldhar · Answer

@Prometheus Hi column E to H is raw data and circled one is calculations and dark Green (column H) is difference which need to be adjusted into H column, example highlighted in I column and result need as coming in J column. so that J column total and circled calculations total should same and different should be zero.

I hope this will help you to understand.

Thanks,

Rajeev

Prometheus · Answer

@Rhaldhar I don't understand what you're asking because the layout of your data is confusing. Which part of your worksheet is the raw data? What are you trying to accomplish?

Rhaldhar · Answer

Hi,

Colum "I" is a example of the +- figure it will not be available in input data on basis of green box difference (.2) it to be split .01 and .01 if the difference is .04 then to be split in 4 row .01, .01,.01, .01. so, please have a look again on the query. Thanks for looking.