Hi.

I'm comparing two columns (A and B) of stock ticker symbols (text
strings). I want to create an if statement in Column C where the
"value if false" is NOTHING. Currently, the statement (in C1) looks
like this:

=if(B1=A1,B1,"")

This formula has been copied from C1 to C100, so that some of the
return values are text values, and some are "". The formula works, but
when I sort Column C, ascending, the "" values precede the text string
values. How can I change my if statement so that a sort (ascending)
will place my first text string (i.e. ABC) in cell C1?

Thanks.
themike