W
William
I have a Pivot Table that I created. I have certain columns that I sort that
using the little drop down boxes that are on the pivot table. In these
columns, about half of the cells are blanks, resulting from a formula. I
sort the columns "Z-A" trying to get the highest value at the top. The
blanks are placed at the very top, as if they are the highest value. I would
like to sort with the the blanks being considered as the smallest values and
being placed at the bottom. How can I do this? Thanks!!!
using the little drop down boxes that are on the pivot table. In these
columns, about half of the cells are blanks, resulting from a formula. I
sort the columns "Z-A" trying to get the highest value at the top. The
blanks are placed at the very top, as if they are the highest value. I would
like to sort with the the blanks being considered as the smallest values and
being placed at the bottom. How can I do this? Thanks!!!