LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple sort Problem kevincanuk Excel Discussion (Misc queries) 2 November 22nd 06 08:05 AM
simple sort, but ... tfb Excel Discussion (Misc queries) 1 October 8th 06 06:43 PM
SORT RESULTS OF A FORMULA (this should be very simple) HERNAN Excel Discussion (Misc queries) 2 July 25th 06 06:44 PM
simple sort maacmaac Excel Discussion (Misc queries) 3 January 30th 06 08:22 PM
Is there a simple way to do a randomizing sort? BrentG Excel Discussion (Misc queries) 1 September 20th 05 04:32 PM


All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"