What is the equivalent formula to the LARGE formula that will sort text rather than number?
Using the formula =LARGE($B2:$H2, columns ($K2:K2)) I can sort numerical data and rewrite to the second array
Is there an equivalent formula that will enable be to do the same with text entered into cells instead of numerical value?
Using the formula =LARGE($B2:$H2, columns ($K2:K2)) I can sort numerical data and rewrite to the second array
Is there an equivalent formula that will enable be to do the same with text entered into cells instead of numerical value?