B
bryhogan
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!
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!