how to organize column according to another column?

Hello Guys,

if I have three columns:

A B C
X1 X3 3
X2 X1 7
X3 X2 9

want column B and C stay organized according to column A:

A B C
X1 X1 7
X2 X2 9
X3 X3 3

where B is adjusted with the A and C fits together with B.

how can I do this simple formula or macro?

thank you very much!

for_forum.xlsx

Sorry, I'll try to explain better. In Annex I to 'Sheet1' I have three columns. The first (column A) to cities in a certain order, the second (column B) with the city that should be in the same order as the city in column A, column C with indices that must fit together with column B.

Originally Posted by FDibbins

Hi and welcome to the forum

If the 1st column is sorted alphabetically, then try to sort B & C alpha, based on B
If this doesnt give you what you need, press CTRL Z to undo and come back here to let us know - well, let us know either way lol

no is not, is a specific order

Originally Posted by :) Sixthsense :)

May be this...

In D2 Cell

Formula:

Please Login or Register  to view this content.

In E2 Cell

Formula:

Please Login or Register  to view this content.

Drag both the formula's down...

the second formula don't work

Originally Posted by FDibbins

OK then try this in D2, copied down...
=VLOOKUP($A2,$B$2:$C$224,1,0)
and in E2, copied down...
=VLOOKUP($A2,$B$2:$C$224,2,0)
I notice there are a few "non-matches", they will show up as #N/A

Work thanks! how to proceed now to avaluate the ans?

for_forum.xlsx

Originally Posted by :) Sixthsense :)

It should work if possible attach the workbook to check where it fails

here, i use the excel in portuguese, then "," is "."

thanks so much

Originally Posted by :) Sixthsense :)

Thanks for the file but it is the same one which you shown in Post #3. I thought you will be showing the formula in your file to check where its getting failed.

Any how forget about my request, since FDibbins suggestion is working for you

is there any plugin to do this function automatically?