Move data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Horacio - 31 Oct 2006 12:27 GMT

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

Reply to this Message

Roger Govier - 31 Oct 2006 12:52 GMT

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.

Signature

Regards

Roger Govier

> Hi!
> I need some help please.
[quoted text clipped - 12 lines]
> Thank you
> Horacio

Reply to this Message

Horacio - 31 Oct 2006 17:14 GMT

> 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

Reply to this Message