StevenPMoffat
asked on
Sorting Data that is both inside and outside a table
I have a single sheet of data. Some of it is in a table and some of it is not in a table (but on the same rows). I want to be able to apply a sort that sorts both the data outside the table and the data in the table at the same time. When I try to select the data outside I can use the Data Sort menu, but as soon as I also select the data in the table, this menu is dimmed out. This leads me to believe that you can't do this type of sort?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER