Setting Up Filters in Google Sheets for Price Comparison
A price list imported into Google Sheets often starts as a simple table with product names, codes, suppliers, and costs arranged across different columns. To make the information easier to review, organize the sheet with a filter first. Select the full data range, including the header row, then choose the filter option from the Data menu. Filter controls will appear on each column, allowing you to focus on specific suppliers, product groups, or price ranges.
Using filters reduces the amount of information displayed at one time, making it easier to notice suitable options. Sorting the price column from low to high can highlight cheaper items quickly, while higher-priced entries become easier to identify. When a file includes separate pricing fields, such as standard cost and supplier discount rates, reviewing the correct column helps create a more accurate comparison.
Using Multiple Column Filters to Narrow the Options
Price alone is rarely enough when comparing products. A useful comparison often requires several conditions, such as checking items from one supplier while limiting the results to a specific budget range. Google Sheets allows multiple column filters to work together, showing only rows that meet all selected conditions.
Using more than one filter helps remove unrelated products from the comparison. For example, a spreadsheet containing office equipment, software licenses, and maintenance supplies can be narrowed by category first, then reviewed by price. This approach creates a more balanced comparison because similar items are evaluated together instead of mixing different product types.
The order of filtering can affect how quickly you find relevant results. Starting with broader categories, such as supplier or product type, usually reduces the list more effectively. Additional filters for price, availability, or other details can then refine the remaining options. Keep in mind that imported data may contain missing values or inconsistent formatting, so checking the original price source is still recommended when a result appears unusual.
Checking for Duplicate or Outdated Entries Before Comparing
Downloaded price lists sometimes contain duplicate rows for the same product or outdated prices that were not removed before export. Before you trust the filter results, check for duplicates by selecting the product name column, opening the Data menu, and choosing Data cleanup then Remove duplicates. Removing extra rows keeps the first occurrence, which prevents the same item from appearing twice with different prices. Outdated entries are harder to spot, but you can add a temporary column labeled “Last Updated” if the original list includes a date column.
Filter that column to show only recent dates, such as entries from the current month or the last quarter. If no date column exists, compare the prices against a known baseline, such as your previous purchase order or a recent invoice. Filtering out old or unverified rows reduces the chance of comparing a current price against a figure that is no longer valid.
Using Filter Views to Save and Share Different Comparisons
If you need to compare prices from the same downloaded list in different ways, such as by supplier or by product type, filter views are more practical than regular filters. Open the Data menu, select Filter views, and choose Create new filter view. Each filter view saves its own set of filter conditions and sorting rules. You can switch between views without resetting the table, and you can give each view a name like “Supplier A Best Prices” or “Lowest Unit Cost”. Filter views also let you share a specific comparison with a colleague without changing the original file. When another person opens the sheet, they see the default table, but they can click the filter view name in the toolbar to see exactly the rows and columns you arranged.
Showing a team member only the items that need price renegotiation or the products that meet a budget target is straightforward with filter views. The original data stays untouched, and everyone works from the same source.
FAQ
Question: Can I filter by color or conditional formatting in Google Sheets?
Answer: No, standard filters do not read cell color or conditional formatting. If you applied color to mark high prices, add a helper column with a formula such as =IF(B2>50, “High”, “OK”) instead, then filter that column.
Question: What should I do if the price column contains text like “$12.50” instead of a number?
Answer: Text values prevent sorting by price. Select the column, open the Edit menu, choose Find and replace, enter “$” in the Find field and leave Replace empty, then click Replace all. After that, format the column as Number so sorting works correctly.
Question: Does filtering change the original downloaded data?
Answer: No, standard filters and filter views only hide rows temporarily. The original data remains in the sheet. To remove filters, click the filter icon in the toolbar again or close the filter view tab.
