adding he;per columns shouldnt alter the the order (sequence?) of your data?
The problem with creating two helper columns is that I need to keep the ordering in order return the MIN-MAX values for specific cells.
Im thinking of something like
in B1 =IF(A1>1,A1,"")
in C1 =IF(A1<1,A1,"")
then you could use...
="$"&MIN(B1:B6)&"-$"&MAX(B1:B6)
and
=TEXT(MIN(C1:C6)*100,"0.0")&"%-"&TEXT(MAX(C1:C6)*100,"0.0")&"%"