"Bill" wrote in message
...
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
The sorting is sorted thanks to a good sort on here. Many thanks. Had a
play as well and found out a few other bits.
All the best
Bill
|