Thread: Sorting
View Single Post
  #1   Report Post  
Bill
 
Posts: n/a
Default Sorting

Can anyone help please.

Column a has numbers 1 thru 311
Column b has the names of colours to match the numbers.

What I need to do is to sort the names of colours in column b
alphabetically, but retaining their present numbers, so if at present row
200 is green and row 201 is azure, I want it to go 201 azure, 200 Green. I
want the present numbers to stay with their colour. hope that makes sense.

I can't do it!

Thanks
Bill