Fixing final changes for The Giving Quiz
Can't figure out the Excel formula for this on Convert Calculator!
I have an array of variables VA, VB, VC, VD. I want to find the top 3 largest values of this array.
I used MAX() to find the largest value.
To break it down to find the individual 2nd and 3rd largest values, I used the LARGE function
LARGE(array, k), where k is the nth largest value I want.
So to find 2nd largest value from the array, I do this LARGE({VA,VB,VC,VD},2)
Ultimately, I will wrap it in a IF condition to hide/show a piece of info:
IF(LARGE({VA,VB,VC,VD},2) = VB,1,0)
But this doesn't work. 😩
I have an array of variables VA, VB, VC, VD. I want to find the top 3 largest values of this array.
I used MAX() to find the largest value.
To break it down to find the individual 2nd and 3rd largest values, I used the LARGE function
LARGE(array, k), where k is the nth largest value I want.
So to find 2nd largest value from the array, I do this LARGE({VA,VB,VC,VD},2)
Ultimately, I will wrap it in a IF condition to hide/show a piece of info:
IF(LARGE({VA,VB,VC,VD},2) = VB,1,0)
But this doesn't work. 😩