how do i sort the nos. in a column in increasing order without changing their values horizonatly. for eg:
a .......... 23
b .......... 12
c ........... 48
d ........... 4
how doni get it this way:
d .......... 4
b .......... 12
a ......... 23
d .......... 48
2006-08-29 23:57:04 · 4 answers · asked by sil marilyn 2 in Education & Reference ➔ Homework Help
All you have to do is highligh both columns and then click "data" on the toolbar then "sort" then just select the column with the numbers. All relationships will stay in tact. godd luck
2006-08-30 00:04:41 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Select both columns and go to Data, Sort
When the window comes up, make sure it sorts using the column with the numbers and viola!
They should keep the same letters with the numbers.
2006-08-30 07:02:56 · answer #2 · answered by chicgirl639 3 · 0⤊ 0⤋
Highlight all the data, and if they are in say columns A and B then you click "data-sort-by column B-in ascending order."
HTH.
2006-08-30 08:42:35 · answer #3 · answered by Mahira 3 · 0⤊ 0⤋
Highlight your column. Go to Data. Press sort. In your case, it must ascending.
2006-08-30 07:02:02 · answer #4 · answered by Ang C 2 · 1⤊ 0⤋