How to Filter Numeric and Currency Data?
Questions:
- How do I filter tables by exact numbers?
- Can I search for a range of prices?
- How do I filter using greater than or less than symbols?
Description:
Find exactly what you need by applying advanced filters to your table data. You can search for exact matches, ranges, or specific thresholds for both numeric and currency values.
We'll show you, step by step, how to:
-
Exact Match: Locate records that match a specific number precisely.
-
Thresholds: Use mathematical symbols to find values greater or less than your target.
-
Ranges: Define a minimum and maximum value to view data within a specific bracket.
Solution:
-
Locate the Column Filter
Click on the filter input box located at the top of your desired numeric or currency column.
-
Filter by Exact Match
Type a specific number (like 10 or 50) into the filter box. The table will update to show only the records that match this exact value.
-
Filter by Greater Than or Less Than
Type the greater-than-or-equal symbol followed by your number (like >=10) to see values at or above that threshold. Use the less-than-or-equal symbol (like <=20) to see values at or below your target.
-
Filter by Range
Type your minimum value, a hyphen, and your maximum value (like 10 - 20) to view all records that fall within that specific bracket.
-
Filter with Decimals and Negative Numbers
You can apply these exact same rules using negative numbers (like -5) or decimal values. Ensure you use the proper formatting for your region, such as a comma for German decimals (like 15,5).
- Demo Video for reference
Tips and Tricks:
Pro-Tips:
-
Currency values follow the exact same filtering rules and formats as standard numbers.
-
If you type an unsupported format or invalid operator (like =>10 or letters), the table will safely ignore the input to prevent errors.
Warnings:
-
Double-check your formatting when using ranges. Typing an invalid range (like 10 -- 20) will not apply the filter.