Determining the First Date with No Transactions

Looking up missing information in a range of data can seem intimidating. In this tip, you discover two different ways to figure out a date based on missing information.

Read this tip »

(Thanks to Ryszard Raciborski, Rick Rothstein, Brian Dorey, James Woolley, Michael Avidan (MVP), Peter McNab, and Julie Faas for contributing to this tip.)

Pasting a Comment into Your Worksheet

Excel allows you to not only put information into cells, but into comments attached to those cells. Here's how to copy the information from a comment into a cell, using techniques you are already familiar with.

Read this tip »

Baffled by Array Formulas?

Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.

Jumping Around Folders

When you open a workbook in Excel, the Open dialog box always starts within the folder in which you were last working. You can use this to your advantage when working in multiple folders, as illustrated in this tip.

Read this tip »

Conditionally Formatting for Multiple Date Comparisons

When you compare dates in a conditional formatting rule, you need to be careful how you put your comparisons together. Do it wrong, and you won't get the result you expect. Here's how to do it right.

Read this tip »

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Calculating Domains and Counts

I have a worksheet that contains our client list. In column D is the email address for each client. I would like to get a list of unique domains from those addresses (the part after the @ sign), along with a count of how many email addresses use each domain. There are several thousand clients in the worksheet.
—Peter Carlson (provide an answer for this Help Wanted question)