General

Conditional Formatting
I am trying to Build a relationship between two different columns. The data comes from two different spreadsheets(SS). I copy and paste them into a third sheet then compare like data. The data from SS1 is in columns A, B, C, D and the data from SS2 is in columns E thru H. How can I format the Countif functi... 31 Aug 2005 15:21

Mileage calculation
I am creating a spreadsheet that will work out how much petrol money a worker can claim back. The claim is based on usage, anything below 666 miles petrol is calculated at 32p and then anything over that petrol is calculated at 16p how can i get the total claim cell to calculate for the example a worker who tra... 30 Aug 2005 07:53

pivot: average vs. median
I'd like to use a pivot table and get a median value rather than an average. Any formula or other way I could do this? Percentile formulas perhaps? The outliers in my data make the average look much too high thanks, dave ... 8 Sep 2005 09:30

Unable to empty clipboard error
I am getting a lot of trouble when using Excel 2003 with the error "Unable to empty Clipboard", generally when I am copying very small amounts of data from an Excel spreadsheet into an Outlook email. After a few sucessful copies, this error message starts popping up. Sometimes it can be ignored and the copy pas... 8 Sep 2005 14:42

Formulas with percentages
maybe someone can help me with this..if someone increases an amount by %25 then they get a point, if they increase it by %50 they get 2 points, by %75, 3 points, and %100, 4 points.... can you figure that one out for me please? how would i a formula that would read this? -- Message posted via OfficeKB.co... 1 Aug 2005 22:18

How do you calculate average time?
I'm trying to track the average time a person uses a piece of equipment at work. The average function does not seem to recognize time less than 1 hour (i.e :37) in duration. I have about 30 occasions when the equipment was used-- ranging from :05 to 3:10. I appreciate your help. ... 30 Jun 2005 14:49

how do i create an automaticly generating number for a document?
I am wanting to create document with automatic document numbers, eg. invoice numbers, that will automatlicly increase with each document i create. Is this possible in excel or word? If so, can someone please explain how? ... 15 Jun 2005 08:28

time
I have set up a spreadsheet with time based on what our company truck drivers work. We work under a DOT rule of 70 hours / 8 days. That means that the driver can not work more than 70 hours in an 8 day period. The sheets I have (one for each month) goes back 7 days plus the current day and calculated how many hou... 15 Jun 2005 07:25

Unable to use Text Box
Several toolbars are wholly or partially "greyed out" (inactive). For instance, Drawing toolbar allows me to use Fill Colour & Line Colour & Font Colour but NOT to use Text Box, Connectors, Auto Shapes and others. Odd thing is that I could use these earlier (an earlier version of same workbook saved previously ... 23 Feb 2005 17:58

Using the sum function in a 3 dimension environment
How to Use the sum function in a 3 dimension environment in Microsoft Excel? Need a detailed description for a research paper I am doing, ASAP!!!! ... 22 Feb 2005 20:25