Most Frequent Value in a Column

If you have a large number of values in a column, you may want to know which of the values appear most frequently. This tip examines a couple of easy ways to get the desired info.

Read this tip »

(Thanks to Steve Aprahamian, Tom Santi, Ryszard Raciborski, Brian Dorey, James Woolley, Rick Rothstein, Kevin Keyser, Bob Farey, John Vander Linden, Michael Avidan (MVP), Steve Peterson, Chris Lefsrud, John Gent, Peter McNab, Bob Beechey, Steven Morgenstern, Michael Valley, Dick Downey, Ronald Doeleman, Fred van der Meulen, Yvan Loranger, and Christos Constantinou for contributing to this tip.)

Printing a Draft Watermark

Adding a watermark to the background of a printout can be challenging. This tip explains the different ways you can implement your own watermarking techniques.

Read this tip »

ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

Determining If a Date is between Other Dates

Need to figure out if one date is between two other dates? There are a wide variety of formulaic approaches you could use to determine the answer. Here are two short and elegant approaches.

Read this tip »

Changing Macro Cell References Based on Edits

Place a cell reference in a macro, modify the structure of your worksheet, and you may soon find that the cell reference in the macro is no longer accurate. While Excel doesn't automatically update cell reference in macros according to changes in a worksheet, you can avoid the problem by changing how you reference cells.

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.

Address of the First Blank Cell in a Column

In column A I have several thousand values, with a mixture of numeric and text values. The column can contain blank cells, as well. Is there a formula I can use that will return the address of the first blank cell in the column?
—Georgi Tarshica (provide an answer for this Help Wanted question)