Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by setting two conditions
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by setting two conditions
If it is true/False
DataSort Sortby Col A Descending Then byColB Descending OR select Data From menu DataFilterAutofilter and filter down Col A with True and then Col B with true If this post helps click Yes --------------- Jacob Skaria "Waveney Johnny" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by setting two conditions
Hi,
filter both columns, then choose true in column A and then in column B if this helps please click yes thanks "Waveney Johnny" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting multiple conditions in one cell | Excel Worksheet Functions | |||
Setting up a drop down box with sort criteria | Excel Discussion (Misc queries) | |||
Setting a default sort for a range | New Users to Excel | |||
Setting up some sort of cutting and pasting loop | Excel Worksheet Functions | |||
setting two conditions for countif | Excel Worksheet Functions |