Dear All,
Thanks to excel group for all the different approaches.
It is really helpful for me to solve the particular query into various
quickest ways.
Thank you Harmeet for your quickest solution.
Dear Santosh, I understood your point also.
Thank you very much.....
On Thu, Sep 3, 2009 at 9:25 PM, santosh bahuguna
<santoshbahug...@gmail.com>wrote:
> if you want to create a macro for it then it can be done easly
> but if you want to perform this with excel then i will be little tricky
>
> (1) first copy unique keys records to another sheet
> * (this you can do with the help of advance filler or
> countif) then goto old data sheet*
> **
> (2) put the count if on the data sheet based on key
> column(=COUNTIF(A$2:A2,A2))
>
> now filler on countif column and select 1 time count keys
> move that data to another sheet
> **
> *(3) now use vlookup function on unique record sheet with you filer out
> with count if*
> **
> *then after rept this until number of duplicate you have*
> **
> *please let me know if you have any problem to understanding this *
>
> **
> **
> *regards*
> *Santosh bahuguna*
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
> **
>
>
>
>
>
>
>
>
> On Thu, Sep 3, 2009 at 12:48 PM, rahul rahul
> <rahulmakhar...@yahoo.co.in>wrote:
>
>>
>>
>> Hi Madhur,
>>
>> What you may wanna do is to run a pivot on the data sheet to see how many
>> ID's does a Key actually have an there by extract the data from the same.
>>
>> Regards,
>> Rahul
>>
>>
>>
>> --- On Thu, 3/9/09, madhur baharani <madhur.bahar...@gmail.com> wrote:
>>
>> > From: madhur baharani <madhur.bahar...@gmail.com>
>> > Subject: $$Excel-Macros$$ NEED HELP on multiple vlookup
>> > To: excel-macros@googlegroups.com
>> > Date: Thursday, 3 September, 2009, 12:28 PM
>> > Dear All,
>> > I need your help.
>> > Kindly find the attached data sheet, query & the
>> > solution which i need is explained in it.
>> > Please help me on the issue since i have to invest a lot of
>> > time in solving it.
>> >
>> >
>> > Thanks in advance.
>> >
>> >
>> > -- --
>> > Thanks & Regards,
>> > Madhur Baharani
>> > OSS Kolkata
>> > Mob: 91-9874459054
>> > Mob: 91-9831804654
>> >
>> >
>> > >
>> >
>> >
>> >
>>
>>
>> Love Cricket? Check out live scores, photos, video highlights and
>> more. Click here http://cricket.yahoo.com
>> >>
>>
--
-- --
Thanks & Regards,
Madhur Baharani
OSS Kolkata
Mob: 91-9874459054
Mob: 91-9831804654
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
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 excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
