*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 <harshsha...@gmail.com> wrote: > HOPE THIS MIGHT BE USEFUL. > > > On 8 July 2011 10:09, L.K. Modi <ca.mod...@gmail.com> 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