 |
||
Publisher's NotesI 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: 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 TipsIf 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 TableSometimes 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. (Thanks to Jose Murillo, Danielle O'Connell, and Clarence Washington for contributing to this tip.) Hiding Rows Based on Two ValuesIt'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. 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 TotalsYou can insert subtotals and totals in your worksheets by using either a formula or specialized tools. This tip explains how to do both. Counting WordsDo 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. 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:
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 WantedThis 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 RangesI 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. |
||
 |
||
 |
||
Publisher and Copyright Information |
