Summing the Largest Values

If you want to calculate the sum of the largest positive and negative values in a column, there are multiple ways you can accomplish the task. This tip looks at some approaches you can use and some considerations you need to take into account.

Read this tip »

(Thanks to Andrew Gray, Steve Aprahamian, Ryszard Raciborski, Jos Graindor, Alex Blakenburg, Brian Dorey, Kevin Keyser, Elliot Penna, Jim Cupec, Thomas Reeves, James Woolley, Michael Avidan (MVP), Stephen Argent, Fred Potter, Mike Haley, John Vander Linden, William Field, Yvan Loranger, and Brian Moreira for contributing to this tip.)

Saving Common Formulas

Got some formulas you slaved over and want to use in lots of workbooks? This tip presents some helpful ideas on how you can save those formulas for easy recall later.

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.

Backing Up Custom Dictionaries

The custom dictionary used in Excel contains the information you decide relative to spelling. After a while, you might start to realize how much work it took to get that dictionary just as you like it. Here's how to back up all that work.

Read this tip »

Saving Movement on Enter with a Workbook

Press Enter when working in a workbook and Excel moves to a cell adjacent to the one in which you were working. If you want, you can adjust the direction in which Excel makes the move. Here's how to save a direction with each workbook you create.

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.

Creating a Calendar

Using the various new array functions in Excel, is there a way to create a calendar for a given month in a traditional 7-column, Sunday through Saturday format?
—Nancy Quintera (provide an answer for this Help Wanted question)