Hi Dilip,
First thing first, Thanks a lot for your response.
I used the file and the formula as suggested by you. However, i am facing
little challenges with the same.
In the example that you have taken (where all the data are starting with a
number), if my data is starting with an alphabet, then this formula is not
working.
Would request you to kindly provide a formula that is equally applicable for
the above mentioned scenario.
Please let me know if you have any questions.
Thanks & Regards,
Ankit Mehra
On 6/24/09, Dilip Pandey <dilipan...@gmail.com> wrote:
>
> Hi Ankit,
>
> Try below formula, right next to your column:-
>
> =IF(ISNUMBER(A2),IF(ISNUMBER(MATCH("*"&A2&"*",A:A,0)),"Keep","Delete"),"Delete")
>
> Now go ahead and filter out the "Delete" rows. Select "Delete" from the
> drop down and use Alt+; key combination and then press delete / or delete
> entire row, as per your choice.
>
> I have created a scenario based on your example and same is attached with
> this email.
> Thanks,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>
>
>
> On Wed, Jun 24, 2009 at 12:29 PM, Ankit Mehra <ankitmehr...@gmail.com>wrote:
>
>> Hello Group,
>>
>> I have an excel file that have large number of data (both numbers and
>> texts). My query relates to detecting the values that are duplicate in
>> nature, however distinguished by a single text or number. For example:
>>
>> Inv Number
>> 123
>> 123A
>> 123B
>> 123C
>>
>> In the above example, the number is same, however an extra text has been
>> entered (A,B,C, etc). To add to the confusion, the length of the text is
>> also not ascertainable.
>>
>> Would request you all if anyone could provide me a way or a macro that
>> finds out these values from a large set of data and then delete the
>> duplicate ones i.e. do not delete 123 and delete 123A,123B,123C.
>>
>> I hope my query is clear.
>>
>> Please let me know if you have any questions.
>>
>> --
>> Thanks & Regards
>>
>> Ankit Mehra
>>
>>
>>
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
