Forum Discussion
Excel formula for Ageing
Hi, I am trying to come up with a formula to net down aged data but I am struggling! This is a sample from my pivot, I want to run the formula alongside it and what I am trying to do is: Fo...
When you refresh the pivot table, make sure your ranges for age categories and amounts remain consistent, as the formula refers to those exact values through VLOOKUP. Adjust the ranges as needed if you change the structure or add more rows or columns.