Sorting columns with expressions

I have a column that says =if(a1=b1,True, False)
and want to sort the column to pull the true values

Yet the sort doesn't do anything, is there a special way to sort these types
of columns?

Hi

You need to include Columns A, B and C in your sort, not just column C.
Then it will sort to bring all the False s together, followed by the True's
Equally, you could mark the data and do Data>Autofilter and use the
dropdown on column C to select True

Regards

Roger Govier



et wrote:

>I have a column that says =if(a1=b1,True, False)
>and want to sort the column to pull the true values
>
>Yet the sort doesn't do anything, is there a special way to sort these types
>of columns?
>
>
>
>

Try -
=if(a1=b1,1,0)
and then sort.

Regards.

Bill Ridgeway
Computer Solutions

"et" <[email protected]> wrote in message
news:%23%[email protected]...
>I have a column that says =if(a1=b1,True, False)
> and want to sort the column to pull the true values
>
> Yet the sort doesn't do anything, is there a special way to sort these
> types of columns?