Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data across multiple columns | Excel Discussion (Misc queries) | |||
sorting data in columns | Excel Discussion (Misc queries) | |||
How do I lock columns together in a single row for sorting purpos. | Excel Discussion (Misc queries) | |||
Regarding Sorting Columns | Excel Discussion (Misc queries) | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions |