How to write an IF/Than formula to pull information into a summary sheet?

Occasional Visitor

I am using a large amount of information and am trying to get rows that are flagged or marked with an X in column to populate a summary sheet within the same workbook. Can anyone help with how to accomplish this?

 

Thank you

1 Reply

@Alex_Newell 

 

You don't need an IF..THEN formula for this. You need the FILTER function (which does require the most recent version of Excel).

Here's a video that explains its use. https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...