Sorting problem

[elayem]

Hi, I'm trying to sort a column w/ an =IF function that returns a blan
cell. When sorted, this blank cell is sorted first (I guess excel see
it as text?) before the numbers. EG

Column A
5
3
8
=IF(B1=1, B1, "")
10

On sort, it will look like:

Column A

10
8
5
3

with the blank cell above the #10. Is there any way that I can get i
to look like:

ColumnA
10
8
5
3

with the blank cell following the 3

 

[Tom Ogilvy]

I only get that if the numbers are actually stored as text. Otherwise the
formula produced blank sorts to the bottom.

 

[Tom Ogilvy]

Sorry - I was sorting ascending and now I see you are sorting descending.

I would sort all the data ascending, then select just the numbers and sort
descending.

--
Regards,
Tom Ogilvy

I only get that if the numbers are actually stored as text. Otherwise the
formula produced blank sorts to the bottom.