Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting data that contains blanks
I have a spreadsheet that has a column containing results from a formula. In
these columns, about half of the cells are blanks, resulting from the 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. How can I get the blanks to be considered as the smallest values and being placed at the bottom. Thanks!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting data that contains blanks
Put something else in the column besides a blank. A simple method is to
modify you formula and put 0 instead of a blank in these cells. "William" wrote: I have a spreadsheet that has a column containing results from a formula. In these columns, about half of the cells are blanks, resulting from the 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. How can I get the blanks to be considered as the smallest values and being placed at the bottom. Thanks!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting data that contains blanks
Thanks Joel. I guess I'll have to do that. I was hoping that the blanks
could be left in because the zeros make the report look sloppy. "Joel" wrote: Put something else in the column besides a blank. A simple method is to modify you formula and put 0 instead of a blank in these cells. "William" wrote: I have a spreadsheet that has a column containing results from a formula. In these columns, about half of the cells are blanks, resulting from the 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. How can I get the blanks to be considered as the smallest values and being placed at the bottom. Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting column with blanks | Excel Worksheet Functions | |||
Help with sorting blanks out of a list | Excel Discussion (Misc queries) | |||
Removing blanks / sorting - common methods not applicable | Excel Discussion (Misc queries) | |||
Sorting by looking for blanks | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |