General

How to find errors in documents
when you have a series of data and you have a space or error in your numbers when you are using functions and formulas. how do you find where there error is in the data if you cant see the space or cant see where the error might be that is causing the formula answer to be wrong. ... 25 Mar 2010 01:02

Error in formula after auto-filtered
In a table, i have one column (let say Column A) where the formula is referred to another workbook. The formula works well, until i do an auto-filtered on another column (Column B). The formula in Column A would then displayed "#Value!". The formula would works well only if i have the other workbook opened. ... 25 Mar 2010 22:03

Pivot Table Default Setting
Can you change the default setting in Pivot Table? For Example if everytime I do a pivot table I do not want it to give me subtotals can I default it that way instead of always changing the setting. ... 25 Mar 2010 01:02

top ten ranking
I have 20 category in each category I have random 1 to 500 items with sales units and Sales $ metric for each items. How can filter and rank it will show up top 10 items of combination for Sales Units and Sales $ Cat 10 Item Sale units Sales $ Rank bread ... 24 Mar 2010 21:40

Calculate times between dates and times in Excel
How can I calculate the time in minutes between 2 events with format (date,hour) or format date in a cell and time in another cell, without weekends and holidays, for employees with 8 hours/day. ... 25 Mar 2010 01:02

Formula copying error
I've entered a vlookup formula and when I copy it to another cell, sometimes it copies the formula correctly into the other cells and comes up with the correct (and different) results but sometimes when I try to copy it, it just copies the previous result--and ignores the vlookup formula altogether. If i go t... 25 Mar 2010 02:10

Hide unused rows and columns
In excel 2007 i would like to hide All rows and columns except for the few i have data entered into. Any advice? Thanks ... 24 Mar 2010 22:47

include rounding in a formula
i have the following: A B C 1 327.2 3033.56 0.107860072 column C1 is simply A1/B1 . Is there a way that i can include in my formula to round the results to 0.11? What I have been doing is creating another column and entering the formula: round(c1,2) then copying and pasting values I am hoping to ... 24 Mar 2010 19:22

Name scope within a workbook
I have 3 different workbooks open. A sheet within one workbook contains a number of named Ranges. When I copy the sheet into one of the other workbooks the Named ranges gets a scoop of the whole Workbook but when i copy the same sheet to the second workbook it only get a Wortsheet scoop. Why? I hope I have made ... 24 Mar 2010 19:22

Repeat labels in Pivot Tables
Is there a way to get excel to repeat the label on a pivot table so that there are no blank fields on the report? ... 24 Mar 2010 18:11