Sort two colums so that equal cells are right next to each other

[MrMoody]

Hi all,

so I have a small excel problem that would save me a lot of time if I could solve it.
I have two colums A and B each with random strings inside.
What I want is that the cells with the same input (so the same random string) are sorted right next to each other.


So colums A and B in the "Before Worksheet" are what I got, and the same colums in the "After Worksheet" are what I want to get. Is this possible in an easy manner?



Thx for your help

[dominicb]

Good morning MrMoody

Welcome to the forum!!

Would you post your .pdf file as an Excel file. It is difficult to formulate a solution from static data that we cannot interact with.

DominicB



Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitise the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[MrMoody]

Thank you for your answer. I just updated the file Thank you in advance

[Special-K]

in Before!C2
=IFERROR(VLOOKUP(A2,B$2:B$23,1,0),"")
and copy down the column as far as C23

[MrMoody]

Thank you for your quick answer . Could u incorperate it into the provided excel file? I am not quite sure how to do it.
Thank you very much

[dominicb]

Hi MrMoody

The methodology of the attached does what you require, but it doesn't follow the methodology of what you have described in your post.

Column J is a copy of what you have in column A.
Column C compares each row in column A with the whole of column B to see if the value in A appears anywhere in B (ie is it a duplicate). The digit is the number of times A's value appears in B.
Column K asks whether the value in J is marked as a duplicate, if so, show the value again, otherwise show blank.

It's a bit off the wall, but it seems to work.

HTH

DominicB

[Special-K]

Thank you for your quick answer . Could u incorperate it into the provided excel file? I am not quite sure how to do it.
Thank you very much

Just type the formula as stated into C2 as you would any data.
Ctrl-C to copy the formula.
Select the cells C3:C23
Ctrl-V to paste the formula.

[MrMoody]

Thank you all for your great help. Sorry it took me so long to come back to you yet I was on hollidays

So your method worked fantasticly dominicb, thank you for that.

Yet I have a second problem.

So as before I have my sample set 1 in colum A and my sample set 2 in colum B. With your Method I managed to align the cells beeing the same seen in colum G and H.
Yet I also have an order asigned to sample set 2, seen in colum C and I need these Numbers right next to their original string in colum B.

You can see the intended result in the "After" Worksheet.

Do you now how to achieve that as well?

Thank you again for your help

[dominicb]

Good morning MrMoody

If I follow you correctly, then something like this should work - copy the formula into cell I2, then copy down.

Please Login or Register  to view this content.

HTH

DominicB

[MrMoody]

Awesome it works Thank you guys for all your help

[dotchiejack]

I see you are from Germany, if you use a German Excel than the formula =

=WENNFEHLER(SVERWEIS(H2;$A$2:$C$49;3;0);"")