make a list of the "TRUE"

[mtbaldyred]

Great site, the archive has helped me get this far, Id appreciate further help though:


I'm working with Excel to get a current list of our (a non profit group's) members. We have no contact management software, just MS Outlook ....

On sheet 1 I have a list of contacts and contact data, exported from MS Outlook

On Sheet 2 I have used =Sheet1!A1 etc to grab the names of the contacts and have used a simple formula to see if an exported ( membership) date has expired =(Sheet1!AA3>TODAY())

NOw Id like to now get a list derived from sheet 2, collected on sheet 3. It should be a list of ONLY the members whose memberships are still valid ( i.e for whom =(Sheet1!AA3>TODAY()) returned TRUE .

Can you tell me how to do this?

 

[Oaktree]

Welcome to the board

Try using data --> filter --> autofilter to filter your column for TRUEs.

Then, copy and paste the filtered list (if filtering alone isn't enough) to sheet3.