Explanation

Excel provides different filter options depending on the type of data.

Text Filters

Examples:

  • Equals
  • Does Not Equal
  • Begins With
  • Ends With
  • Contains

Example:

Customer → Begins With → A

Number Filters

Examples:

  • Equals
  • Greater Than
  • Less Than
  • Greater Than or Equal To
  • Between
  • Top 10

Example:

Sales → Greater Than → 10,000

Result:

Customer

Product

Sales

Rahul

Monitor

25500

Priya

Printer

24000

Date Filters

Examples:

  • Today
  • Yesterday
  • This Week
  • This Month
  • Before
  • After
  • Between

Practice

Using the sales dataset:

  1. Sales greater than ₹10,000
  2. Customer contains “A”
  3. City equals Sirsa
  4. Sales between ₹5,000 and ₹25,000
PreviousNext