Excel Tips
September 19, 2022
I have a lengthy report with invoice detail by customer. I need to add a subtotal at each change in customer.
Replace Multiple Filter Criteria with a Single Row of Formulas »
September 16, 2022
The Advanced Filter feature can handle combinations of criteria, but I have a particular situation where I want all records where the customer, industry and product come from these lists. To list all combinations of five products, five customers, and three industries would require 75 rows of combinations. Is there an easier way?
September 15, 2022
As the AutoFilter Filter gets more features, there are less times that you need to switch over to the Advanced Filter. There are still a few tasks that might be easier with the Advanced Filter.
Find the Unique Values in a Column »
September 14, 2022
I have a large database. Before I can produce a report for each customer, I need to identify the complete list of unique customers.
September 13, 2022
I don’t want to offer filter dropdowns for Quantity and Revenue. It confuses the people who use my worksheet. I only want the filters to be available on columns A:D.
September 12, 2022
I need to total only the visible cells in a filtered data set.
Filter by Selection like in Microsoft Access »
September 8, 2022
Microsoft Access offers an icon for Filter by Selection. Why isn’t this in Excel?
September 7, 2022
I need to select all the oil companies from the filter.
Quickly Filter a List to Certain Records »
September 6, 2022
I have 10,000 records in the worksheet. I need to be able to quickly find records that match a criterion, such as all East ABC records.