How to Use SUMPRODUCT to Create Two-Dimensional Lookups in Excel Formulas

Array Formulas Charley Kyd - 0
A friend recently asked, "In this table, how can I return the date where the lowest value occurs?" More generally, however, he was asking how to...
SUMPRODUCT is one of Excel's most-powerful function for summarizing data. It offers much of the power of array formulas, but without the complications.

How to Use SUMPRODUCT in Excel to Summarize Worksheet Data

Aggregation Functions Charley Kyd - 0
After I posted  The Most Powerful Ways to Summarize Excel Data for Reporting and Analysis, a reader asked why I hadn't discussed the SUMPRODUCT function. I told him...
Excel's four better-known functions for rounding numbers are: INT, ROUND, ROUNDUP, and ROUNDDOWN. Here's how to understand and use them in your Excel work.

How to Use Excel’s Better-Known Rounding Functions: INT, ROUNDUP, ROUNDDOWN, & ROUND

Formulas & Functions Charley Kyd - 0
Excel has one way to round up or down from the first generation. In recent generations it has also offered a second method. And...
Excel's absolute cell references, like $A$1, confuse many Excel users. But the explanation is easy. Each dollar signs serv only one important purpose.

How to Use Absolute and Relative Cell References in Excel Formulas

Worksheet Interaction Charley Kyd - 0
A reader sent me this question: Could you send me more details about using $'s like the following: =AVERAGE($6:$6) averages all data in ROW 6....
Here's how to use a formula that returns TRUE or FALSE in Excel's conditional formatting feature to highlight rows that contain specific numbers or text.

How to Use Conditional-Format Formulas to Change Background Colors

Conditional Formatting Charley Kyd - 0
"I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...

How to Use Advanced Filters to Create Unique List of Items from an Excel...

Excel Methods Charley Kyd - 0
(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...
Array formulas may be Excel's most-powerful feature for summarizing data. But they're also a little-used feature of Excel. Here's how to use their power.

How to Summarize Spreadsheet Data with Excel’s Array Formulas

Array Formulas Charley Kyd - 0
Subtotals can reveal very useful management information. For example, managers might be interested to learn that sales increased by 10% last month. But they would...
In Word, we can set up custom forms, and then tab through them to enter our data. Here's how to tab through forms in your cells in your worksheets.

How to Tab From Cell to Cell in an Excel Worksheet Form

Worksheet Interaction Charley Kyd - 0
As a general rule, it's a good idea to find a way to import data from some other source, rather than entering the data...
You can sort data with formulas in two ways. One way requires Excel 2019 and above. This article explains how to sort data in all versions of Excel.

How to Sort Data in Reports Automatically Using Excel Formulas

Formulas & Functions Charley Kyd - 0
Many Excel reports include tables that show sorted results. Usually, these tables were sorted manually in Excel, using the Data, Sort command. However, reports...
You can set up cascading list boxes so that your second list of items changes depending on which item you selected from the first list. Here's how to do it.

How to Set Up Cascading List Boxes for Filtered Excel Reports

Data Management Charley Kyd - 0
When each item in a primary list is associated with a different collection of items in a group of secondary lists, you can use...
1...101112...22Page 11 of 22