Move data

[Horacio]

Hi!
I need some help please.
In a spreadsheet in column A i have numbers from 1 to 100 and in column
B I have data from some other spreadsheets.
Wat I wont to do is, if the data in column B change for another row then
the number in column A change to the same row of that data in column B.
Ex:
1 a
2 b
3 c
If the c move to the 1º place in column B I need the number 3 also in 1º
place
Thank you
Horacio

 

[Roger Govier]

Hi Horacio

Select columns A and B
Data>Sort>chose Column B either Ascending or Descending
Provided both columns are selected, the numbers in column A will alter
in line with changes in the order of data in column B.

 

[Horacio]

Roger Govier escreveu:

Hi Horacio

Select columns A and B
Data>Sort>chose Column B either Ascending or Descending
Provided both columns are selected, the numbers in column A will alter
in line with changes in the order of data in column B.

Thank you Roger
Horacio