Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel |