Sorting a row which contais data repeted atleast once

[swathyp]

hi,

I have an exel like follows

name adress
anu 10a,bg
swathy 15c,fg
paru 10a,pc
nandu 16n,mc
binu 17d,ld


I need to sort the address column and get the details which contains same details.I need an o/p as follows

name adress
anu 10a,bg
paru 10a,pc

here adress of anu and paru having a 10a common.I have a huge data.any simple way to sort it out??

please help....

[Marcol]

I have a huge data.any simple way to sort it out??

Going by what you have posted, yes, but I suspect there is a little more to your problem.

You would do best to post a sample workbook showing some typical data and sheet layout.
It should clearly illustrate your problem and not contain any sensitive data.

Cheers

[swathyp]

ExelProb.xls

Thanks for response

I am attaching the workbook herewith

[Marcol]

Hi

Sorry to be a pain, but please use the forum facilities to upload files.

Members, including me, are reluctant to download from unknown sources.

From Forum FAQs

How do I attach a file to a post?

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

[swathyp]

Sorry..

pls find the file attached as per your instruction

[Marcol]

Try this workbook

I suspect that you will need more combinations of codes/details than you are suggesting in your example.

I have provided a step-by-step solution to help you understand how the formula is built.

And then a hard coded one step solution.

Change the values in E1 and / or in H1 to see the result in columns K:L.

N.B. Columns N:O will not change, they are hard coded as in your example request.

Hope this helps.

[noexcel=badwork]

the best way is to make it in a table
by this way, you will make sort as you
like. here I attach the file
hopefully that help you

[swathyp]

Its OK..But I said na mine is a huge database.I just dont want to sort the data which contains the same data in the begining or end of of a row.I want to sort the all rows where any data repeated anywhere in the column may be with the combination of any other data seperated by coma or space.

What I am saying is I am not aware 10A or FG will repeat.I need to sort all data which are repeated

[Marcol]

Are you saying that the detail/code could have more than two parts, and each part could have a varying number of characters?

Or is it always "3 characters" comma "2 characters"?

[swathyp]

Exactly what you said first.details can have more than two parts,that is separated by coma or space.

[Marcol]

This has an unlimited number of possibilities!
However try this workbook

I have provided a step-by-step solution to help you understand how the resulting formula is built.

It might be a fair starting point for a VBa solution, or maybe just something to give the Formula whiz-kids a good laugh....

Use the grouping buttons, ( the + sign in the bar below the formula bar), to follow the various steps.

What you do with the result is up to you, because there is a possibility of the same record falling into more than one condition, I can't take it any further.

Hope this helps, and have fun..
This should give you something to do this afternoon.... ..

Regards
Alistair

[swathyp]

Thats Superb..But my exel have 4000 entries and more than 600 data repeted in many rows.I need to sort with all this 600 data? Is there any other possibilities?

Is there any support through Phone.I can make a call and clearly say my issue

[Marcol]

Your question is quite clear, the only thing that is missing is the data style and layout of your workbook.

Can you post a cut down version of your workbook with any sensitive data disguised?

A VBa solution is obviously what you are after, and a sample workbook will make this so much easier.

Cheers

[swathyp]

Please find the attached list.I need to sort column B[Remarks].if any data repeated those details alone I need

[Marcol]

I can't see how this relates to your original question.

There is no character anywhere in your list that can be described as a delimiter, other than " "(Space).
I'm fairly sure that's not what you want.

Take this line

contact person Contact Number (preferably Cell number)02317981 Unit Model NumberHCL Unit Serial Number9876A4055803 AMC/WarrantyAMC Problem DescriptionC mos battery is changed with new one Bios settings is changing Some time system goes off

How do you see that being split?

I'm afraid I can't see what can be done with this.

Can you explain further?

[swathyp]

See the 3323 and 3324 th row.it contains the same details...there may be more rows contains the same details.that may be the office no,ph or may be name...want to sort this kind of data

TVM10091457 C063A1243945 Manager ph 9995437143 Office 0472304101
TVM10091458 C063A1243945 Manager ph 9995437143 Office 0472304101

[Marcol]

I'm at a loss here, do you just want to detect duplicate remarks?

If so
1/. Sort your data on ColumnB ("Remarks")

2/. In C2

Please Login or Register  to view this content.

Drag/Fill Down to end of Data.

3/. Filter Column C for non-blanks

This will show you where there are duplicate remarks.

What then?
Each duplicate appears to have a different Call Number, which one gets retained?

How does this relate to your original question?