Ravi Sir's Cards › Excel
FILTER with conditions
Revision card: FILTER with conditions. Example data table with All Pune rows: Amir and Shahrukh; Pune OR Nashik: Amir, Zoya, Shahrukh; Amounts over ₹1,000: None.
Read card text
What this card says
FILTER with conditions
Example
data table with All Pune rows: Amir and Shahrukh; Pune OR Nashik: Amir, Zoya, Shahrukh; Amounts over ₹1,000: None
Learn this in the lesson: Excel FILTER Function: Return All Matching Rows, Multiple Conditions, Starts With and #SPILL! Error