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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks