Is there a way to get the Autofilter Sort function to ignore columns
that have a forced blank ("") result in them? I'm trying to sort a
column with a formula in each cell that results in either a % or a
blank result (""). When I sort descending, Autofilter puts the blank
results at the top of the list.

The ideal solution would be something that let me do this...

- if(isblank($A1),INSERTBLANK(),B1*C1)

vs.

- if(isblank($A1),"",B1*C1)

Any help would be greatly appreciatd!


--
bryhogan
------------------------------------------------------------------------
bryhogan's Profile: http://www.excelforum.com/member.php...fo&userid=8879
View this thread: http://www.excelforum.com/showthread...hreadid=498680