Hello,
I need to write a function that returns a data set's name by comparing two parameters of the data set. I am trying to rank the data sets in an order from "Highest" to "Lowest".
The ranking is primarily done with the first parameter of the data set from highest to lowest (i.e., 10 over 8). The second condition only comes into play if the data sets have the same value for parameter 1. If this is the case, the "Highest" data set is the one with lowest parameter 2 value (i.e., data set <10,0> is ranked before data set <10,1>).
Any assistance with this would be appreciated. I would like to develop 3 functions, one for determining the highest, 2nd highest and lowest data sets. I've attached an example file if the text is confusing.
Bookmarks