-Macros$$ Help regarding bank statment
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote:
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in
*hi LK modi
use this simpler formula
=LOOKUP(2,1/(A1:A10=A2),B1:B10)
file is attached
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Jul 8, 2011 at 10:56 AM, harsh shah wrote:
> HOPE THIS MIGHT BE USEFUL.
HOPE THIS MIGHT BE USEFUL.
On 8 July 2011 10:09, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
> format. and in column B
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that is in different
format. and in column B the balance as on the respective dates.
As the bank charges interest on the clos
