Forum Discussion
innovative way to display data
Dears, Need your expert advice for the below, Is there an innovative way to display the attached data model in a clear and understandable way (customer indebtedness and its payments) Thanks in ...
hussein_elsayed Let me know if this set of results makes sense, if the numbers are what you'd expect.
I am using the new FILTER function which requires the most recent version of Excel.
My guess is that you'd be well served in the other reports as well with the FILTER function. Here's a YouTube Video that explains it. https://www.youtube.com/watch?v=9I9DtFOVPIg
Is there any way to consume the dues amount based on total collection from the collection details sheet to be consumed from earliest due date till consuming the total collection in the collection details sheet
I'm sorry: I don't understand the question. I realize English may not be your first language, but I'm not really able to figure what you mean by "consume" and its variations.
May I ask if the work I did send you made any sense. Or is it there that you're looking for total dollars owed in the various categories of delayed payment?