| Thread | Last Post | Replies |
|
| Formula needed please... | 11 May 2008 22:43 GMT | 4 |
This is probably simple to you guys, but I can't seem to get it to work. I need a formula that will add together the sum of A1, A2, & A3 cells, then display (in A4) 20% of the total? Hope this makes sense.
|
| How do I find formula to calculate a year's salery | 11 May 2008 22:34 GMT | 1 |
How do I find a formula to get a year's salary
|
| Insert row in Office 2007 | 11 May 2008 18:22 GMT | 3 |
Can someone advise me how to insert more than 1 row a time. Thanks, Scott
|
| The macros in this project are disabled. | 11 May 2008 18:16 GMT | 2 |
From the ControlBox when clicking on the Exit Design Mode button, I get a message: The macros in this project are disabled. This is preventing me from running my project.
|
| Pivot Table Formatting | 11 May 2008 18:07 GMT | 1 |
I have read past posts on Pivot Table formatting and have achieved some success with the formatting problem. My current problem is that on one spreadsheet I have used AutoFormat to get the look I want for the Pivot Table. On this table I expanded the width of
|
| Filter question | 11 May 2008 17:55 GMT | 2 |
I have a Pivot Table in Excel 2007 with data. I have a Date column. I need to filter the data so it shows me the data from 01-01-2008 and today date minus 1 day. I would like to have the data filtered automatically (without having to go everyday manually and change the filter ...
|
| pivot table | 11 May 2008 15:13 GMT | 2 |
I have been tasked with putting together a pivot table for my group that will highlight if a persons vacation falls within blackout dates. Right now I have a list of names and a start and end date for there vacations. I also have a list of blackout dates set up with start and end ...
|
| delete blanks cells | 11 May 2008 13:55 GMT | 1 |
Sir, How to delete filtered Blanks Cells Thanks Hardeep kanwar
|
| combine sheets | 11 May 2008 12:26 GMT | 3 |
I have a workbook with 50 worksheets. And i want to combine 50 sheets into one sheet Is it possible? If yes then how
|
| Simple formula request | 11 May 2008 11:07 GMT | 5 |
From http://www.socialsecurity.gov/OACT/COLA/piaformula.html There is this paragraph; For an individual who first becomes eligible for old-age insurance benefits or disability insurance benefits in 2008, or who dies in 2008
|
| Validation Criteria & Ignore Blank (cells at bottom) | 11 May 2008 05:48 GMT | 3 |
I have a named list that has a bunch of blank cells at the bottom so the user can grow the list as needed. The ignore blank check box in data validation looks tempting, but I still get all the blank cells at the bottom of my drop down list. Does anyone know how to get it so
|
| Two XLStart Directories | 11 May 2008 01:46 GMT | 5 |
I seem to have two XLStart Directories: C:\Program Files\Microsoft Office\OFFICE11\XLSTART C:\Documents and Settings\GB\Application Data\Microsoft\Excel\XLSTART Do I need both? I remember having some problems when I added some xla files
|
| Sum all sheets | 10 May 2008 23:16 GMT | 5 |
I have a workbook, with multiple sheets, each with it's own name. Each sheet has a cell, ie N25, which represents a count function on that sheet. Now, I would like to place the sum of N25 of all the sheets on a summary sheet. Is it possible to do this with or without using a ...
|
| Conditional colours in Lookup table | 10 May 2008 18:01 GMT | 5 |
I have a table that reports results from a lookup table. The results are in column "L" I am wanting specifics to be highlighted. If a cell reports "sam" or "jim" to be blue etc.
|
| How can I get the mode of a range? | 10 May 2008 17:32 GMT | 1 |
I would like to know the most frequently occurring number in a range on my spreadsheet, but =mode(c4:u4) is invalid. It looks like it wants =mode({1,3,1,5,... etc.). How can I convert my range into a form the Mode function likes?
|