Excel Geeks

We haven't played one of these fun games in a while, so lets see what you can come up with.

Columns J, N, R and V will contain a value of 1, 2, 3, or 4
The value in Column F will be assigned either 1, 2, 3, or 4 depending on the following criteria:
Looking at J, N, R and V, looking for the best 3 out of 4 highest performing values (1 is lowest performing, 4 is highest performing).
Examples:
J=1, N=2, R=3, V=3, then the value in F would be 2
J=1, N=1, R=1, V=4, then the value in F would be 1
J=2, N=1, R=3, V=4, then the value in F would be 2
J=1, N=3, R=3, V=4, then the value in F would be 3
J=2, N=4, R=4, V=4, then the value in F would be 4

Watcha got?

 

Use the large function: =LARGE(array,3)

 

Ask Siri

 

I'm not really understanding how you're calculating F.

 

Nevermind, now I get it. As @Yzasserina said, use either the large or small array function (mine is not using the usual array brackets because it wasn't needed in this case).

 

Sounds like third best or second worst.

 

Thanks!!! Never knew those functions existed!