Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting column with blanks
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting column with blanks
If you replace 0 with some negative value in data, then it might help you. A
serious workaround is needed here. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "William" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with sorting blanks out of a list | Excel Discussion (Misc queries) | |||
Removing blanks / sorting - common methods not applicable | Excel Discussion (Misc queries) | |||
Replace all non blanks in a column with column header | Excel Discussion (Misc queries) | |||
Sorting by looking for blanks | Excel Discussion (Misc queries) | |||
Creating a column of numbers from a column with some blanks? | Excel Discussion (Misc queries) |