I have a situations where I have to sort a Priority List which can take values from A20 - A1 and B20 - B1. However, many of those values are currently missing. Can I sort the variables in a descending order (all the 40 variables) so that when the currently missing values appear in future, this will be automatically sorted in the dashboard? ... View more