Forum Discussion
formula
It has been awhile since i've used this and cannot remember how to sort, I have 2 columns as shown
7612 colour me white
6013 scene
I need to sort both columns so they go by number and the fresh matching 2nd column goes with it
If someone could refresh my memory I would appreciate it
1 Reply
Simply select the two columns. Make sure that the active cell in the selection is in the number column.
Then select Sort & Filter > Sort Smallest to Largest in the Editing group of the Home tab of the ribbon.
