Allen Wyatt's ExcelTips (menu)

ExcelTips
(menu interface)
19 May 2012

Publisher's Notes

Tips

Looking Backward through a Data Table

Hiding Rows Based on Two Values

Using Subtotals and Totals

Counting Words

Help Wanted

Copying Named Ranges

Web Addresses

ExcelTips (menu)

ExcelTips (ribbon)

Tips.Net Store

ExcelTips Archives

ExcelTips Premium

Advertising

Help Wanted Questions

Contact Info

Help Wanted Answers

Editor and Publisher

Twitter


(Click above for more info)

Publisher's Notes

I need the help of every red-blooded ExcelTips subscriber. I would like each of you to search your memory and come up with one person (only one) that you know would benefit by subscribing to ExcelTips. It shouldn't be that hard to come up with a single person.

Got that person in mind? Good! Now, forward this copy of ExcelTips to them and invite them to subscribe. Or, print it out and hand it to them if you don't know their e-mail address. Let them know what you think about ExcelTips and how it has helped you. Your one person can sign up by visiting the ExcelTips website and using the sign-up form at the upper-right of any page:

http://excel.tips.net

Don't put it off; contact that *ONE* person right now. If you put it off, you will forget about it. After all, we're all human and our time is stretched pretty thin. But if you do it right now, you'll have it over and done with.

—Allen

Tips

If you have an idea for a tip, send it our way. Any tips contributed will be credited in the issue in which they appear. You can learn more about the tips in this week's issue of ExcelTips by clicking the links provided below.

Looking Backward through a Data Table

Sometimes you need to look backward, through the information above your formula, to find the data you need. This can be done with a variety of formulaic techniques, as described in this tip.

Read the full tip...

(Thanks to Jose Murillo, Danielle O'Connell, and Clarence Washington for contributing to this tip.)

Hiding Rows Based on Two Values

It's easy to use filtering to hide rows based on the value in a cell, but how do you hide rows based on the values in two cells? Here are a couple of ideas on how you can pare down your data.

Read the full tip...

Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

Using Subtotals and Totals

You can insert subtotals and totals in your worksheets by using either a formula or specialized tools. This tip explains how to do both.

Read the full tip...

Counting Words

Do you need to know how many words are in a range of cells? Excel provides no intrinsic way to count the words, but you can create a quick macro that will provide the figure.

Read the full tip...

Need More ExcelTips?

You are reading the free version of ExcelTips. There is another version you could be reading right now: ExcelTips Premium. This week ExcelTips Premium subscribers also learned about:

  • Editing Comments
  • Getting Rid of Everything Except Numbers
  • Shading Based on Odds and Evens
  • Automatically Advancing by a Month

Each weekly newsletter is in a professional PDF layout and presents double the tips (Premium subscribers see articles you won't in regular ExcelTips) with great, useful graphics. Plus, ExcelTips Premium subscribers get valuable money-saving benefits. For more information (including a sample issue), visit the Tips.Net store.

Help Wanted

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.

Copying Named Ranges

I have a workbook that has a large number (120+) named ranges defined within it. I would like to copy the range names and definitions to a different workbook. Thus, after copying, the range named MyRange1 which refers to the range C7:H22 in the original workbook will exist in the target workbook and refer to the same range. Nothing else should be copied from the original workbook to the target—just the range names and definitions.
—Graeme Brokman (provide an answer for this Help Wanted question)

 
Tips.Net

Publisher and Copyright Information
ExcelTips is published weekly by Sharon Parq Associates, Inc., PO Box 794, Orem, UT 84059. Copyright 2012 by Sharon Parq Associates, Inc., All Rights Reserved. All broadcast, publication, or retransmission is strictly prohibited without prior written permission from the publisher. ExcelTips is part of the Tips.Net network. Full information on distribution rights can be found in the FAQ at the ExcelTips Web site.