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:

 

[flying008]

Hi, @RVDL 

Please try this way:

[caltang]

Similar concept to yours, but mine is overengineered haha!

[Qiu]

@RVDL 
A bit late for the party.
I was trying to use Tile tool and end up many other tools.

[RVDL]

@caltang @Qiu @flying008 Thank you all for your help. Always nice to see how a problem can be solved in various ways.

[caltang]

If it helps, you can mark all three as possible solutions too! It helps to close this thread and helps others with similar problems to you to find the solution more quickly.

Thanks,

Cal