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

--
elaye
-----------------------------------------------------------------------
elayem's Profile: http://www.excelforum.com/member.php...fo&userid=1534
View this thread: http://www.excelforum.com/showthread.php?threadid=26965