Hey..Dilip that was great... On Tue, Jun 16, 2009 at 4:16 PM, Dilip Pandey <[email protected]> wrote:
> Hi ac737, > > This is actually a good query. Same is solved and attached. Thanks. > Dilipandey > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > [email protected] > [email protected] > New Delhi - 110062 > > > On Tue, Jun 16, 2009 at 4:41 AM, ac737 <[email protected]> wrote: > >> >> Hi, >> >> I have two lists. One list is a bunch of fund names and the other >> list is a bunch of different fund families (not necessarily related to >> the bunch of fund names). I'm trying to figure out how many of the >> funds are ones that are present on the fund family list. So to better >> illustrate what I'm talking about: >> >> Let's take for example: >> A list of Fund Names >> >> AB I >> AB II >> AB III >> CAB I >> YELLOW CAB I >> XY I >> XY II >> GALAXY I >> >> and a list of fund families >> AB >> XY >> MARTIAN >> CAR >> CAB >> >> I'm trying to see how many of the fund names are from the fund >> families. >> >> In this case, the ideal result would be: >> >> AB 3 >> XY 2 >> MARTIAN 0 >> CAR 0 >> CAB 1 >> >> Any help would be great. >> >> Thanks! >> >> >> >> >> >> >> -- With Warm Regards, Amol Balwant Shende, --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
