Dynamic sorting
Hi
Is there a way I can sort a list of names based on a value in the next column where the values can change depending on the date I select from a drop-down?
I don't mind if the sorted list is generated in a different column
Example: The value in the Num column below will change if you select a different date.
Date: [drop-down]
List Num Sorted
Amber 16 Silver
Green 41 Amber
Violet 41 Brown
Silver 10 Grey
Brown 23 Green
Grey 23 Violet
I've tried RANK() but it doesn't handle duplicate values.
RE: Dynamic sorting - formatted table
List___Num____Sorted
Amber___16____Silver
Green___41____Amber
Violet__41____Brown
Silver__10____Grey
Brown___23____Green
Grey____23____Violet
RE: Dynamic sorting - formatted table
List___Num____Sorted
Amber___16____Silver
Green___41____Amber
Violet__41____Brown
Silver__10____Grey
Brown___23____Green
Grey____23____Violet
RE: Dynamic sorting - formatted table
Hi Richard
Just checking if you solved the sorting question.
If you use a pivot table you can make the list sort automatically though you will have to select Refresh.
Set the Row column to colour
Set the Value to Num (Sum of Num)
Then right click the value column of the pivot table and choose smallest to largest. Tie breakers will be sorted alphabetically by colour.
Hope that helps as an option.
Regards
Doug
