how to organize column according to another column?

[Artur_Indio]

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!

[:) Sixthsense :)]

Hi Artur_Indio,

Welcome to the forum

Please attach a sample workbook with expected output for better understanding

[Artur_Indio]

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.

[:) Sixthsense :)]

May be this...

In D2 Cell

=IF(COUNTIF(B:B,A2),A2,"")

In E2 Cell

=IFERROR(VLOOKUP(A2,B:C,2,FALSE),"")

Drag both the formula's down...

[Artur_Indio]

May be this...

In D2 Cell

=IF(COUNTIF(B:B,A2),A2,"")

In E2 Cell

=IFERROR(VLOOKUP(A2,B:C,2,FALSE),"")

Drag both the formula's down...

the second formula don't work

[:) Sixthsense :)]

the second formula don't work

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

[Artur_Indio]

for_forum.xlsx

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

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

[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

[Artur_Indio]

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

[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

[Artur_Indio]

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?

[ionamartin123]

is there any plugin to do this function automatically?

[FDibbins]

ionamartin, please dont ask questions like this on some-one elses thread (its called hijacking lol). Start your own thread, and if you feel it is relevant, post a link back to this thread - and include in your thread what you mean by "any plugin"...these were just regular excel functions