Selecting and extracting TRUE values from sorting by order of dates

[ajoseph08]

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

[#2 · Accepted solution]

@ajoseph08 

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.

[#3]

@Hans Vogelaar Thank you!