Forum Discussion
Solved
Selecting and extracting TRUE values from sorting by order of dates
Hi, I have a large data set that includes pairs of dates. For example, I have dates in columns B and C, and I only want to select and use rows in which the B date is earlier than the C date. To d...
Make sure that you have headers in row 1.
On the home tab of the ribbon, select Sort & Filter > Filter to turn on AutoFilter.
Click the filter arrow in the header of the column with the TRUE/FALSE values.
Clear the check box for FALSE, then click OK.
You can work with the filtered data, or copy them to another sheet.
Make sure that you have headers in row 1.
On the home tab of the ribbon, select Sort & Filter > Filter to turn on AutoFilter.
Click the filter arrow in the header of the column with the TRUE/FALSE values.
Clear the check box for FALSE, then click OK.
You can work with the filtered data, or copy them to another sheet.
HansVogelaar Thank you!