RE: $$Excel-Macros$$ Help regarding bank statment

2011-07-08 Thread Rajan_Verma 
See if it help,

 

Use this in L2

 

=OFFSET(INDEX(F:F,MATCH(K2,F:F,0),1),COUNTIF(F:F,K2)-1,-4,1,1)

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Friday, July 08, 2011 11:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-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 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 closing balance for particular dates. So
there are many balances as on the same date.

 

What i need first that the date should be in format of dd-mmm-yy and
secondly like there are many balances of 1st june so i need only the closing
balance of 1st june and so on. it means last line that is in 1st june this i
have to do for all dates.

 

can anyone help me as this is more time taking without proper direction.

 

Thanks in advance

 

Regards

LKModi

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 

Regards

 

Ashish Koul

 <http://akoul.blogspot.com/> akoul.blogspot.com
http://akoul.posterous.com/

 <http://akoul.wordpress.com/> akoul.wordpress.com

My <http://in.linkedin.com/pub/ashish-koul/10/400/830>  Linkedin Profile

 

P Before printing, think about the environment.

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Copy of test sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help regarding bank statment

2011-07-07 Thread ankur 
*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.
>
>
> 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 the balance as on the respective dates.
>>
>> As the bank charges interest on the closing balance for particular dates.
>> So there are many balances as on the same date.
>>
>> What i need first that the date should be in format of dd-mmm-yy and
>> secondly like there are many balances of 1st june so i need only the closing
>> balance of 1st june and so on. it means last line that is in 1st june this i
>> have to do for all dates.
>>
>> can anyone help me as this is more time taking without proper direction.
>>
>> Thanks in advance
>>
>> Regards
>> LKModi
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


bank statement.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help regarding bank statment

2011-07-07 Thread harsh shah 
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 the balance as on the respective dates.
>
> As the bank charges interest on the closing balance for particular dates.
> So there are many balances as on the same date.
>
> What i need first that the date should be in format of dd-mmm-yy and
> secondly like there are many balances of 1st june so i need only the closing
> balance of 1st june and so on. it means last line that is in 1st june this i
> have to do for all dates.
>
> can anyone help me as this is more time taking without proper direction.
>
> Thanks in advance
>
> Regards
> LKModi
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


test_sheet(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help regarding bank statment

2011-07-07 Thread ashish koul 
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
> format. and in column B the balance as on the respective dates.
>
> As the bank charges interest on the closing balance for particular dates.
> So there are many balances as on the same date.
>
> What i need first that the date should be in format of dd-mmm-yy and
> secondly like there are many balances of 1st june so i need only the closing
> balance of 1st june and so on. it means last line that is in 1st june this i
> have to do for all dates.
>
> can anyone help me as this is more time taking without proper direction.
>
> Thanks in advance
>
> Regards
> LKModi
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


test sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Help regarding bank statment

2011-07-07 Thread L.K. Modi 
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 closing balance for particular dates. So
there are many balances as on the same date.

What i need first that the date should be in format of dd-mmm-yy and
secondly like there are many balances of 1st june so i need only the closing
balance of 1st june and so on. it means last line that is in 1st june this i
have to do for all dates.

can anyone help me as this is more time taking without proper direction.

Thanks in advance

Regards
LKModi

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


test sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet