Sort by setting two conditions

  • Thread starter Thread starter Waveney Johnny
  • Start date Start date
W

Waveney Johnny

I want to sort a spreadsheet so that I can see which records fulfil two
conditions, at the same time. So - col a has true or false. Col b has true or
false. I can easily sort each col, but I can't work out how to set it so that
it will sort to be true/true. Is there a way to do it? Any help appreciated.
Thanks
 
If it is true/False

Data>Sort>
Sortby >Col A > Descending
Then by>ColB > Descending

OR
select Data> From menu Data>Filter>Autofilter
and filter down Col A with True and then Col B with true

If this post helps click Yes
 
Hi,
filter both columns, then choose true in column A and then in column B

if this helps please click yes thanks
 
Back
Top