How to Use SUMPRODUCT in an Excel Table to Filter Any Number of Items
Excel 2007 introduced the powerful Table feature, as illustrated below. Tables allow you to sort and filter your data easily.
However, the filter capability has...
Use a ‘Visible’ Column in Formulas to Ignore Hidden Rows in Filtered Tables
Excel Tables, introduced in Version 2007, give us the ability to use column filters to hide rows in a Table.
And slicers for Tables, introduced...
Two Ways to Set Up Multi-Criteria Lookup Formulas in Excel
The Excel Table below illustrates a common type of lookup problem…perhaps taken to a slight extreme.
Here, we have a specific manager for each month...
How to Use Advanced Filters to Create Unique List of Items from an Excel...
(Note: Filters have changed a lot since this page was written. It's scheduled for a complete makeover.)
When we work with data in an Excel...
How to Report Periodic Data from Excel Databases
Sometimes, the best way to solve your Excel problem is to redesign your workbook.
Ron G. brought this thought to mind with a recent question....
How to Read and Update Excel Tables Using SUMIFS and INDEX-MATCH
A growing number of Excel users in business are linking their reports and analyses to Excel tables. By doing so, they can update them...
Create Variable-Length, Dynamic Reports Linked to Excel Tables
Excel Tables are a powerful feature introduced in Excel 2007. Not only can you report from them directly, you can use them as a...
How to Set Up a Pivot Table as an Excel-Friendly Database
You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs).
In...
How to Add Advanced Filter Capabilities to Excel Tables
One useful feature of Excel Tables is the ability to filter any number of columns. The filter control for each column allows us to...
How to Perform Multiple Table Searches Using the SEARCH & SUMPRODUCT Functions in Excel
SUMPRODUCT is one of Excel's most-powerful worksheet functions. Here, for example, you can use it in one formula to search text in one cell...
Latest Articles
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement