SOLVED

Selecting and extracting TRUE values from sorting by order of dates

%3CLINGO-SUB%20id%3D%22lingo-sub-3070463%22%20slang%3D%22en-US%22%3ESelecting%20and%20extracting%20TRUE%20values%20from%20sorting%20by%20order%20of%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3070463%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20large%20data%20set%20that%20includes%20pairs%20of%20dates.%20For%20example%2C%20I%20have%20dates%20in%20columns%20B%20and%20C%2C%20and%20I%20only%20want%20to%20select%20and%20use%20rows%20in%20which%20the%20B%20date%20is%20earlier%20than%20the%20C%20date.%20To%20do%20this%2C%20I%20used%20the%26nbsp%3B%3DB%3AB%3CC%20formula%3D%22%22%20which%3D%22%22%20gave%3D%22%22%20me%3D%22%22%20trues%3D%22%22%20and%3D%22%22%20falses.%3D%22%22%20i%3D%22%22%20want%3D%22%22%20to%3D%22%22%20be%3D%22%22%20able%3D%22%22%20to%3D%22%22%20select%3D%22%22%20the%3D%22%22%20true%3D%22%22%20rows%3D%22%22%3E%3C%2FC%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EAnna%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3070463%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 Replies
best response confirmed by Sergei Baklan (MVP)
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.