Moved to the Excel Twitters archive:
Excel Twitters 20090605
 
|
Do you have two or more web pages that you use frequently? I like Google as a home page, and use it many times during the day. I also refer to my own website several times, to make sure everything is working okay, or look up one of the Excel tips that are stored there. I had Google set as my home page in Firefox, then opened Contextures.com later.
It's not a terribly painful process, but I've found a way to set multiple home pages, instead of one. Set Multiple Home PagesHere's how I set up the multiple pages: On the Firefox toolbar, click Tools Click Options Click the Main heading, then click the Use Current Pages buttonThe URLs will appear in the Home Page box, separated by the pipe separator. Click OK, to close the Options dialog box. The next time you open Continue reading Create Multiple Home Pages in Firefox Usually when I use VLOOKUP, I want to pull information for an exact match. For example, if I enter a customer number in one cell, I want the customer name in the adjacent cell. I don't want the name of a customer whose number is CLOSE to the one that I entered. In some situations though, an approximate match is preferred, so several values will return the same result. For example, when working with student grades, I don't want to create a lookup table where I have to enter every possible percentage. Instead, my lookup table should have the starting percentage for each grade. Based on the table below, all percentages of 85 or over should receive an A grade. The Lookup Table In this example, the lookup table is created on a sheet named Grades. To create the lookup table: In the first column, enter the minimum percentage Continue reading Convert Percentages to Letter Grades With VLOOKUP  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
Recent Comments