Ranking column values

RVDL

Hi All,

Suppose I have the following table:

Name	Test1	Test2	Test3
Aa	81	70	81
Bb	90		95
Cc		23

Now for each row, I need to rank the values from high to low, and take the middle value.

For the first row, the ranking is 81, 81, 70. The second value now is 81.

For the second row, the ranking is 95, 90, - . The second value is 90.

Note - ranking from low to high and taking the middle value also works of course.

If a row only has one value, we simply take that value.

Thus I want to end up with a table like:

Name	Test1	Test2	Test3	Final
Aa	81	70	81	81
Bb	90		95	90
Cc		23		23

I have no idea how to do this. Some help would be appreciated. Thanks.

caltang

You can do it like so:

For RVDL.yxmd