I have a list of numbers.
This list is not sorted and I don’t want to sort it.
I want to use the second highest in a formula or calculation (2nd*B2*G14 or even another calculation or formula). How do I do that?
Would it incorporate the RANK formula?
This list is not sorted and I don’t want to sort it.
I want to use the second highest in a formula or calculation (2nd*B2*G14 or even another calculation or formula). How do I do that?
Would it incorporate the RANK formula?