Min Function

[jonathanzadeh]

Hi Guys,

I have a sample of data 3 columns. One contained a ID, one containing a "variance" and one containing a price. One ID can have multiple variance and price associated with it. What i would like to do is, select the ID with the smallest variance. However, one ID can multiple variance which are the same, so the next criteria for the selection is the one with the smallest price. Hence, is there a way to select the min variance, followed by the min price for that variance?

See Example:

ID     Variance       Price

1           3                 $1

1           2                 $3

1           2                 $6

2           1                 $1

2           1                 $3

2           3                 $6

So in the above case, for ID "1" the selection will take the smallest variance and then select the smallest variance with the smallest price. Hence ID 1 with a variance of 2 and price of 3 will be selected. Any way to do this? 

[patrick_digan · Accepted solution]

@jonathanzadeh Use a sort tool (ascending by Id, Ascending by variance, Ascending by Price in that order) and then a unique tool with ID selected. 

[mceleavey · Accepted solution]

i @jonathanzadeh,

No problem.

Solution attached.