Forum Discussion
Formula not working - Dynamic array for subtraction
looks like you have lots of ZERO values that I'm guessing you want to ignore also? Maybe try:
=IFERROR(LET(range, BD3:BO3, filled, FILTER(range, range<>0), last, TAKE(filled, , -1), previous, TAKE(DROP(filled, , -1), , -1), IF(last=previous, last, previous-last)), "")
Thanks! HansVogelaar for trying to help me.
I still couldn't get the output expected after applying the above Formula, the output is "0" only returning . PFB
I'm kindly attaching the spreadsheet for your reference to ease the intention for supporting me. Please help me to get a working formula.
Sheet name: Dump paste
Range experimented: BD3 to BO3 on getting the output at range BP3.
Excel version: MS-Excel 365 updated & compatible for using advance functions
Trouble shoots tried:
1. Ensured No empty values at the given range
2. Number format is in "General" only.
3. Other simple formulas working in the experimented range BD3 to BO3
looks like you have lots of ZERO values that I'm guessing you want to ignore also? Maybe try:
=IFERROR(LET(range, BD3:BO3, filled, FILTER(range, range<>0), last, TAKE(filled, , -1), previous, TAKE(DROP(filled, , -1), , -1), IF(last=previous, last, previous-last)), "")