Setting the Zoom Level by User

Excel allows you to set the zoom level for a worksheet to whatever makes it easiest for you to work with your data. If you have multiple users working with a workbook, you may want to set the zoom level based on who has the workbook open at the current time.

Read this tip »

(Thanks to Steve Aprahamian, Brian Dorey, Alan Cannon, Jos Graindor, Michael Avidan (MVP), Ryszard Raciborski, and Thomas Reeves for contributing to this tip.)

Setting a Transparent Color for an Image

Want to "see through" an image you place on a worksheet? You can do so by using the steps in this tip.

Read this tip »

Serious about Sorting?

Organize your data in the order that makes sense to you. Excel's sorting tools make it easy to get at the data you need. Get a firm grip on sorting today and your data management tasks will be easier than ever!

Converting UNIX Date/Time Stamps

If you import information generated on a UNIX system, you may need to figure out how to change the date/time stamps to something that Excel can recognize and work with. The conversion is easy, once you understand the way in which the date/time stamps are figured.

Read this tip »

Rounding to the Nearest Quarter Hour

When entering times in a worksheet, you may have a need to round whatever you enter to the nearest 15-minute increment. There are a variety of ways you can approach this problem, as you learn in this tip.

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.

Extracting Values Appearing More than Twice

I have a column of unsorted values, comprising more than 2,500 rows. I would like to extract a list of values that appear more than twice in the column. Is there a formulaic way to do this?
—Nolan Roberts (provide an answer for this Help Wanted question)