Sorting columns with expressions

[et]

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?

 

[Roger Govier]

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

 

[Bill Ridgeway]

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

Regards.

Bill Ridgeway
Computer Solutions