Limiting the Number of Results from a Function

Some of the newer functions in Excel can return quite a bit of information. If you want to limit what is returned, then you need to enlist the help of a few other functions, as described in this tip.

Read this tip »

(Thanks to Michael Avidan (MVP), Ryszard Raciborski, James Woolley, Bob Beechey, Peter McNab, and Craig Korfanta for contributing to this tip.)

Evaluating Formulas

Need a bit of help in figuring out how Excel is evaluating a particular formula? It's easy to figure out if you use the Evaluate Formula tool.

Read this tip »

Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

Saving a Workbook with a Preview

When you save your workbooks, Excel can also save a preview image (thumbnail) that can be displayed in the Open dialog box. Here's how to configure Excel to save that preview.

Read this tip »

Using a Single Password for Multiple Workbooks

While password protecting a workbook does provide some security for the contents in the workbook, if you have several workbooks it can become cumbersome to access each file with a separate password. This tip explores how you can get rid of some of the bother by using a single password for multiple workbooks.

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.

Sorting by Military Rank

I volunteer for a veteran's group. I put our members in a workbook based on where they provided their service, such as Army, Navy, Air Force, etc., one worksheet per service branch. One column on each worksheet is the member's current rank or rank when they retired. Is there a way to sort the membership on a single worksheet based on rank?
—Arnie Wilson (provide an answer for this Help Wanted question)