how do i format sub sections in a pivot table
... 11 May 2010 03:33
Data Validation - Conditional List
I have two drop down windows and I want the list of values available in drop down two to be dependent on the selection from the first drop down. Example: Drop down #1 - Department 1. Accounting 2. HR 3. Marketing Drop down #2 - Projects to Charge 1. Accounting can charge projects: 1,2,3 2. HR can cha... 10 May 2010 17:41
How to make "X" have the value of 1?
In an excel spreadsheet, how can I make "x" have the value of 1 so the column is totaled automatically? ... 10 May 2010 16:34
Where does Max keep his files now ?
I used to go to save project or something like that to check his sample files. But I have lost the address now. Does anybody know where it is ? ... 11 May 2010 06:47
custom format changes to special
I need to regularly reformat numbers in cells into a custom number (000000000). I create a formatted cell and place a number 1 in it (000000001). I thne copy it and use paste special multiply. This has work great reformatting cells until this week. I tried it and now the cell formats itself into Special Soci... 10 May 2010 07:41
Auto insert sheetname into chart title?
Hi I'm using Excel 2003 I have several charts on a worksheet. At the end of each month I copy the sheet to become the first worksheet in the workbook, delete the data and rename the sheet for the following month. All my charts have a chart title e.g "Total income for April 2010". The sheetname is A... 9 May 2010 11:04
In Excel how do you rearrange a list of address's in alphaeticalo
On 5/8/2010 2:40 PM, Bernard Liengme wrote: Are the parts of the address in separate cells? And you you have headers? A B C D Street Town Province Pcode 100 Main Street Sometown NS B3J A1D If so, select any cell in the data and use Data > Sort and use Pcode as the major sorting 'key' best wishes... 8 May 2010 17:49
Method of viewing/naming columns or conversions for same
Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire workbook carry the same format? ... 8 May 2010 18:55
COUNT unique letter in a column
Howdy All, I want to count the number of occurrences of a partipular letter in a column Any help? THanks, Brian ... 8 May 2010 17:49
Another Sumif problem
A B C D E 1 col tot subtot1 subtot2 DISC 2 black 12 1 11 AA 3 white 14 2 12 BB 4 blue 16 3 13 ... 8 May 2010 06:51