Forum Discussion
Arranging data presentation even an idea on excel
may I ask for assist regarding the attached sheet.
If I have a list of units (B) that have dues in different dates (E) and different amounts (D) also I have the payments as described from column (I) To column (AU). Every payment including (clear date - amount - Receipt Number), then the calculated fieled (AY) and i need to organize these data to be easier for tracking
I need also to make an aging for total Remaining (AY) per unit, per month and year
Thanks in advance
If I have a list of units (B) that have dues in different dates (E) and different amounts (D) also I have the payments as described from column (I) To column (AU). Every payment including (clear date - amount - Receipt Number), then the calculated fieled (AY) and i need to organize these data to be easier for tracking
I need also to make an aging for total Remaining (AY) per unit, per month and year
Thanks in advance
- You have posted on the Microsoft Learn community board which is all about exams, certification and training.
You might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral
