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 DataAutofilter 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" wrote in message
...
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?