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.