How to get a date value from one column to a cell in front of another column based on value of a third column

MuhammadZiaUrRehman

New Member
Joined
May 14, 2016
Messages
9
Hey guys so the problem that i am trying to solve is that if the Exchange Diff amount in Total Column is less than or equal to any of the Receipts Value, then, in the value column, the date for that receipt must then show.
If some how the Exchange Diff amount is more than any of the receipts amount, then the first dates of Total whose sum make more than or equal to the Exchange Diff amount must be shown in the value column bifurcating total amount into new rows for that total amount of that Exchange diff.

If this can be done in Power Query in Excel or by any other formula, it will be really helpful to me.

DescriptionReceipt DateTotalDocument NumberValue
Bill 100,0004000
Receipt02.01.2019-10,0004000
receipt02.03.2019-20,0004000
Receipt15.03.2020-50,0004000
Exchange Diff-20,0004000
Bill200,0004001
Receipt01.04.2020-30,0004001
Receipt10.04.2020-50,0004001
Receipt20.04.2020-30,0004001
Receipt25.04.2020-20,0004001
Exchange Diff-70,0004001
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top