If we require more than two conditions or want to analyze a list using Excel's database functions, so which filter we must define?

Mr. Talha you are wrong. The right answer to my question is that we use Advanced Criteria Filter for analyzing a list in MS Excel.

use if conditions but all depends on actual requirement