Log In
Register
Home
August 25, 2017
Offline
I would like to sort the data in Column B. Then sort based on color. I used the sort key, but it did not work.
Can you help me to understand what steps I failed to do?
Thanks
August 25, 2017
Offline
Here is the attachment
VIP
Trusted Members
June 25, 2016
Offline
Hi mymalone
In your column B, there are no duplicate colors for the same set of numbers. So if you sort by numbers first you will not see any difference.
If (for example) there are two blue cells for the number 7, then you will be able to see the sorting effect with colors.
If you need the colors to be sorted in a specific order, you will need to add additional sorting levels and choose the colors as per diagram below.
Hope this helps
Sunny
August 25, 2017
Offline
Sunny
The data in Columns C:AL did not sort. Only columns A and B sorted properly. How would I sort the entire area?
Thanks
VIP
Trusted Members
June 25, 2016
Offline
Hi mymalone
Did you select the entire area? In what way is the data not sorted properly? It is working for me.
It will first sort column B based on its value and then sort the same values based on the colors in the order(s) specified by you.
The sorting involves the entire row and not just column B (unless you only selected column B)
Hope this helps.
Sunny
1 Guest(s)
