Last Person to Save a Workbook

If you have a need to know who last saved a workbook, there are several ways you can derive that information. This tip looks at three different methods for accessing what you need.

Read this tip »

(Thanks to Ryszard Raciborski, James Woolley, and Andrija Vrcan for contributing to this tip.)

Rounding to the Nearest Half Dollar

When working with financial data, it's easy to round values to the nearest dollar. What if you want them rounded to the nearest half dollar, however? There are a couple of ways you can determine the rounded value.

Read this tip »

Lookup Exactly the Data You Want

Excel's lookup functions are easily the most powerful worksheet functions you can use. Master these seven functions you'll never again view a worksheet full of data in the same way. The power these functions provide you is anything but small. Take your first step today!

Getting Rid of Leading Zeros in a Number Format

Excel, by default, displays numbers with a leading zero, if they are less than 1. Here's how you can get rid of those leading zeros if you don't want to see them.

Read this tip »

Checking if a Workbook is Already Open

Knowing if a workbook is already open can be a prerequisite to your macro working correctly. Here's how to check it out.

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.

Listing the Top Five Transactions

I have a list of transactions in a worksheet. The first column is a customer name and the second is the transaction amount. I know I could sort or filter the data to determine the top five transactions. However, I wonder if the top five customers and the transaction amount could actually be returned by a formula.
—Terri Vargas (provide an answer for this Help Wanted question)