Functions

Vlookup, sumproduct, if, sumif... erggg!
Sigh.... Can only get it to work halfway. I'm thinking I've had to much caffeine and overlooking something. Or my very basic skills just are not up to the task. LOL Sometimes a little knowlege sometimes gets dangerous! What I have and need: *2 worksheets:BILLS(think checkbook register), RAP (think bank statemen... 2 Feb 2010 17:30

Inserting Lines Makes Formula Inactive
I downloaded a Microsoft template called General Ledger (Green, multi-sheet/one per account code plus YTD Budget Summary and Monthly Expenses sheets). The workbook uses the name manager and some other field names that I can't find definitions for. The document worked fabulously until 1/1/10. Now, when I ... 2 Feb 2010 22:27

reference sheet number not name
Hello Is there a way to reference a sheet name based on its number rather than its name? Thanks ... 2 Feb 2010 17:30

I have a file that is 4mb. Cleared all formating...still big
I have found that deleting ALL columns to the right of my required data and ALL rows below was effective in removing unwanted formatting. Crude perhaps, but it works. Just today I reduced a 4mb s/sheet to 275k. Best o' luck On 28 Jan, 16:47, JDH <J...(a)discussions.microsoft.com> wrote: I have a file that... 2 Feb 2010 17:30

help with Conditional formatting pairs of cells
I have a spreadsheet which is laid out as a burial ground map showing who is buried where and whether a headstone is in place. 2 cells represent one grave as there may be 2 people buried there. The format has 4 conditions: Empty used used+memorial reserved. The sheet has 10 columns of around 20 pairs o... 2 Feb 2010 17:30

How do I reference a worksheet name through a formula?
I would like to reference a cell to obtain a worksheet name rather than have the worksheet name in the formula. So rather than have Sheet1! in the formula I would like to have a cell that contains the text "Sheet1" ... 2 Feb 2010 17:30

HOW TO USE BAHTTEXT FORMULA
HOW CAN USE BATHTEXT FORMULA FOR CONVERT FIGURE IN TO WORDS PLEASE EXPLAIN STEP BY STEP ... 28 Jan 2010 05:20

Can I invert a matrix in Excel 2007?
Is there a function in MS Office 2007 Excel that will 'invert a matrix'? That is, I want my columns to become rows and rows to become columns in the new matrix. ... 2 Feb 2010 17:30

Summing weekly values to fall into correct month
Hi, Could someone please help me with this . My spreadsheet has row data in weekly buckets . I would like these weekly amounts to be summed to form the corressponding monthly total . However , some weeks are split across 2 months. For e.g. w/c 28/06/10 has 3 days that fall into June and 4 days that fall in... 2 Feb 2010 17:31

cannot change datasource of pivotchart
I have PivotChart that is showing the number of opportunities of each type in each financial quarter. I want to include a bar to show the total of each type but the PivotChart wont let me change the data source. Is there a way around this? ... 27 Jan 2010 23:55