Dear Experts
I have Balances of 5 years and needs to segregate them to there age, More
than 5 Years, More than 4Years, More than 3 Years, More than 2 Years, More
Than 1 Years, Less than 1 Year. Can You help me out how to distribute them.
They should be segregate by LIFO(Last in first out) basis.
Kindly provide inoput and output data format
It will be more helpful to solve your quarry
On Thu, Jan 12, 2012 at 5:21 PM, Muhammad Arslan arslanacca...@gmail.comwrote:
Dear Experts
I have Balances of 5 years and needs to segregate them to there age, More
than 5 Years, More than 4Years, More
Ok For your reference see attached file
On Thu, Jan 12, 2012 at 4:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Kindly provide inoput and output data format
It will be more helpful to solve your quarry
On Thu, Jan 12, 2012 at 5:21 PM, Muhammad Arslan
arslanacca...@gmail.comwrote:
Dear
still not getting what u want in output,
Kindly give one example of it in excel
On Thu, Jan 12, 2012 at 5:42 PM, Muhammad Arslan arslanacca...@gmail.comwrote:
Ok For your reference see attached file
On Thu, Jan 12, 2012 at 4:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Kindly provide
me too
From: PrIyAnKa p.dhamsa...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 12 January 2012 5:51 PM
Subject: Re: $$Excel-Macros$$ Receivable Aging
still not getting what u want in output,
Kindly give one example of it in excel
On Thu, Jan
Dear Aralan,
could u put the value which u want like.
From: Muhammad Arslan arslanacca...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 12 January 2012 5:42 PM
Subject: Re: $$Excel-Macros$$ Receivable Aging
Ok For your reference see attached
Now i revised workbook, Colum A To Y contains and Cloumn AA To AF contains
results which i wants (desired outcome). Results are manually calculated,
which i want to be come through formula as number of customer are many,
which manually needs a lot of time and work.
--
FORUM RULES (986+ members