Forum Discussion
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 do this, I used the =B:B<C:C formula which gave me TRUEs and FALSEs. I want to be able to select the TRUE rows (B date < C date) and use them for further analysis, what is the best way to do that?
Thanks,
Anna
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.
2 Replies
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!
