Extracting Values Appearing More than Twice

If you need to extract duplicate values from a larger list of values, there are multiple ways you can do it. If you need to extract only those values where the duplicate count is above a threshold, then the solution can be a bit more challenging. This tip provides some ideas you can use to get the values you need.

Read this tip »

(Thanks to Steve Aprahamian, Ryszard Raciborski, Andrew Gray, Don Small, Peter Burns, Kevin Keyser, Brian Dorey, Fred van der Meulen, Andrija Vrcan, Haig Johnson, Gerald DeGraaf, Jacques Raubenheimer, Dick Downey, Patrick Sedgwick, Michael Avidan (MVP), Ken Kast, Ronald Doeleman, Andrew McIsaac, Nick Rea, and Christos Constantinou for contributing to this tip.)

Formatting Axis Patterns

Create a chart in Excel and you can then modify it almost any way you desire. One modification is to adjust the color or pattern applied to an axis. This tip examines the ways you can do this.

Read this tip »

Journal Your Life

Journals go by many names--diaries, sketchbooks, or simply blank books. Regardless of the name, though, journals provide a way for you to record, track, create, dream, and illustrate your life. Journals make it not only possible, but easy. Check out our complete line of high-quality, convenient journals today!

Custom Formats for Scientific Notation

Excel allows you to format your numeric values in a wide variety of ways. One such formatting option is to display numbers in scientific notation. Unfortunately, Excel only provides a single way to display scientific notation. Here's a way to work around that limitation, however.

Read this tip »

Searching for All

When you are working on a worksheet (particularly a large one), you may want to search for and possibly copy information from many cells all at the same time. This is easier said than done in Excel, as this tip illustrates.

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.

Generating a List of Customers and Transaction Dates

I have a worksheet that contains customer transaction information from the past 18 months. The data requires many rows and columns. Using this data as the source, I need to generate a list of customer names (from column A) and transaction dates (from column D) that are unique. Thus, a customer could easily appear multiple times in the generated list, but never would the same customer appear more than once on the same date.
—Brenda Paulson (provide an answer for this Help Wanted question)