Sorting columns with expressions

  • Thread starter Thread starter et
  • Start date Start date
E

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?
 
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
 
Back
Top