Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gshock

    Setting Column Margins on the Header and Footer for Excel

    Help: I want to be able to set the header and footer margins in Excel when i change the margins in the main body. For instance if i change the margin to 1.50, i want the header and footer margin to change to 1.50. Thanks in advance.
  2. gshock

    Excel - Determine if a number IS Odd or Even

    Trying to find a way to validate a number by determining whether the number is odd or even (a true or false argument). Help is kindly appreciated. Thanks.
  3. gshock

    Excel vlookup and referencing

    Hi: Thanks for the reply, however, in playing, I found my answer, I used a combination of the "if" and "iserr" formula in excel which solved my woes. Thanks.
  4. gshock

    Excel vlookup and referencing

    Hi all: Having a problem - want Excel to be able to look up a date and based on that date, return a specific value. If the criteria does not match, than formula should return "blank" or 0. I tried using "vlookup" with "false" as the 4th arguement, however, keep...
  5. gshock

    Time Function

    I am assuming you want this pop up box so that it reminds you of important events. Instead of using excel to do this, you might to better off to use Outlook's calendar functions. In here, you can set appointments, reminders, contacts, etc... I use it and it's great. Cheers.
  6. gshock

    Pivot Table - Totals and Subtotals

    Thanks for the help :). However, in this case, averages only work if you are dealing with one product (i.e. gasoline prices). Can't compare apples with oranges. Cheers.
  7. gshock

    Pivot Table - Totals and Subtotals

    For instance, if you have price in column 1, qty in column 2, and total (prc * qty) in column 3, it does not make sense to have totals for price, it may for qty, and definitely for totals. Hope this helps. Rgds,
  8. gshock

    Pivot Table - Totals and Subtotals

    I just want the pivot table to calculate totals for certain columns without having to cut and paste the table; and then modifying it every time I select a different criterion. I was hoping that the pivot table was similar to MS Access where you can define what columns you want totaled. Cheers
  9. gshock

    Pivot Table - Totals and Subtotals

    Hi Doroth: Maybe I should elaborate - The "GRAND TOTALS" are part of the pivot table, hence, you can not delete the "cell" to get rid of the totals under the 1st and 2nd (price & qty) column. What I would like the pivot table to do, is when it does the "GRAND...
  10. gshock

    Pivot Table - Totals and Subtotals

    Need help!! Here's the scenario - have 3 columns 1st column is price, 2nd is quantity and the 3rd is amount (qty * price). At the bottom, under the GRAND TOTAL ROW, Excel sums up every single column, how do you get rid of the sum for the 1st and 2nd column (leaving the 3rd column intact)...
  11. gshock

    Switchboard Manager

    Have a major problem - under "Startup" under the "Tools" menu, I unchecked "Allow Full Menus" and now a lot of the menus are missing things such as "Tools" under the menu bar. Also, I can't even access the "Switchboard Manager". How can I...

Part and Inventory Search

Back
Top