Hallo. I have found this wonderful formula. =LARGE(ABS(IF(ISNUMBER($F$29:$F$340),$F$29:$F$340)),ROWS($1:1)) It find the largest absolute values in a column. HOWEVER, I keep running into problems. The current one is that I want the values to be in order of absolute value but I would still like to see if the original value was positive or negative. The formula just shows the value as absolutes...no negative or positive signs Helpie.
Bookmarks