Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple(?) Sort Problem
I have text in col. A and numbers in col. B, but there are also "empty rows"
in between. Column B (including the cells in an "empty" row) contained formulae which, prior to sorting, were converted to numbers (with "Paste Values"). The formulae resulted in "" when not true. The problem arises when I try to sort by Col. B descending, then the "empty" cells come out on top and this is not what I need. Obviously they contain something (Blank?) Any way of solving this problem except having the original formulae resulting in Zero instead of "", which would solve the descending sorting, but not the ascending one... Felix |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple(?) Sort Problem
Hi Felix,
Try this, After you sort select all the blank cells at the top of column B. Right click and select delete Check 'Shift cells up' and OK HTH Martin "Felix" wrote in message ... I have text in col. A and numbers in col. B, but there are also "empty rows" in between. Column B (including the cells in an "empty" row) contained formulae which, prior to sorting, were converted to numbers (with "Paste Values"). The formulae resulted in "" when not true. The problem arises when I try to sort by Col. B descending, then the "empty" cells come out on top and this is not what I need. Obviously they contain something (Blank?) Any way of solving this problem except having the original formulae resulting in Zero instead of "", which would solve the descending sorting, but not the ascending one... Felix |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple sort Problem | Excel Discussion (Misc queries) | |||
simple sort, but ... | Excel Discussion (Misc queries) | |||
SORT RESULTS OF A FORMULA (this should be very simple) | Excel Discussion (Misc queries) | |||
simple sort | Excel Discussion (Misc queries) | |||
Is there a simple way to do a randomizing sort? | Excel Discussion (Misc queries) |