hello,
Colum C has the results of Col A - Col B.
In D i want a formula that gives me the top 10 largest variances, but i want them to be displayed as they are (negative or positive).
currently i'm using {=large(abs(B:B),1)} entered as an array, which gives me the correct numbers. But if the largest variance is -500. the result from the array formula is giving me it as +500.
does anyone know of a way to get around this?
Colum C has the results of Col A - Col B.
In D i want a formula that gives me the top 10 largest variances, but i want them to be displayed as they are (negative or positive).
currently i'm using {=large(abs(B:B),1)} entered as an array, which gives me the correct numbers. But if the largest variance is -500. the result from the array formula is giving me it as +500.
does anyone know of a way to get around this?