General

Pivot Table
I want to format a pivot table in such that each of the blank cells in a column can be formatted to be blank instead of the words (blank) in the cell. ... 12 May 2010 18:07

Pivot Table/Conditional Formatting Guru Help
I have a Pivot Table that is based off a view in SQL Server. My Row Labels are products and my Column Labels are the last eight weeks (based on Sunday's date); each week the data rolls one week.. My Total column for the pivot table is an Average. I would like to apply a conditional format to the last two wee... 12 May 2010 20:21

Macro-total a column with different row sizes
I'm trying to create a macro and I'm having trouble with the last part. I want to total a column (E) but the number of rows will vary day to day. For example this totaled today's file with 726 rows but tomorrow's file might have 800 or 500 rows. How do I account for the various row size? Range("E13").Se... 14 May 2010 01:57

Accounting question
This is not an Excel question but I know there are experts here who I know will provide an answer. There is an estate of a deceased person to distribute. Net value is £112k which includes the value of a car (£2500) Two persons are the beneficiaries. Person A - has sold the car for £2500 and has had £300... 13 May 2010 13:50

Auto Page Numbering Question
I have a 12 page pricelist. Recently we made changes to the last 4 pages of this sheet. I am not getting ready to have the last 4 pages printed and sent to my customers so that they can simply replace the last 4 pages, leaving the first 8 in tact. I copied the last 4 pages into a new book, and need the page num... 12 May 2010 14:45

formula for CF
Excel 2007. I've read other threads but somehow the answer eludes me. All I need is shaded row(s) if the answer in E is "done" then shade that row. Simple spreadsheet cols A-E, rows 6-35. Formula ...? I can get the cell to shade with Equal to ... 13 May 2010 10:30

Variable Range in Formula
I'm stuck on this one, hopefullly someone can help. I have the following formula: =SUMPRODUCT((B2>=$B$5)*(B2<=$B$6)) Well "B2" in this formula is supposed to a variable range, but it wont calculate right. So I created a bunch of different range names on sheet2 (i.e., B1:B100, A3:A7, etc...), and in B2 of s... 12 May 2010 14:45

Excel Column Renumbering Question
If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to automatically renumber in sequence after I remove variuos rows? -- clacount ... 12 May 2010 13:38

conditional formatting
I want to format column I (highlight cell) under the following condition the value in same row column F is > 0 and the cell in column I is empty. I have put the following code in the formula bar for conditional formatting and I'm getting an error. How do I fix the problem? First I select column I, and then ... 12 May 2010 12:31

Unique Values, not Unique Records
My data looks like the following: ID Type Amt 1234 A $10.00 1234 B $10.00 1234 C $10.00 I would like to find a way to get only one of the items on to a new spreadsheet, because they are duplicate records in my eyes. The Advanced filter d... 12 May 2010 15:53