I just tried the check template that can be found at the...

Hi Guys I need an array formula which counts the number of instances range Comp1 has a value greater then zero AND Range Comp2 has a blank value. Sounds...

I need a formula similar to the countifs function offered in excel 2007. I'm using excel 2003 and can't upgrade to 2007. I want to add together cars at a...

Wondering if someone would be able to help me with this: A B C Year Year Service 01-Sep-89 30-Jun-10 = 21 Years Teachers From September 1, 1989 to...

How to Display formula Excel uses for internal functions such as (STDEV, STDEVp, STDEVpa ...) It would be useful to see what formula Excel us using at any...

Hi, I have a workbook with the first worksheet (main) as a general worksheets containing the results. All the other worksheets contain scores (SBOz1, SBOz2,...

Hi I have a simple 1000 row table and I am interested in only the data in the columns shown below. Proj Code Name PC01 colin PC01 fred jones

I am trying to write an average formula that takes into account the blank cells. I had only cells A2, A4, A6 filled out, but when I do =average(A1:A6), it is...

Working in Excel, I am looking for help using fill-in boxes. I am creating a form. Setting up a cell or a bunch of cells merged where you can enter a...

I have an application where I need to update cell B5 in Sheet 1 with a cell value from a specific cell (C4) on Sheet 2. The issue is that in this instance, I...

I have a Detail worksheet with three named ranges: Category, DateOfService and Amount. I have a Summary worksheet where I am trying to summaries the amounts...

Is it possible to concatenate a range using only Excel's built-in worksheet functions? Yes, I know it can be done in a UDF, and I can do that. I'm...

My problem is lets say I know I want to buy a total of A apples in equal bunches until I have reached A. However these purchases will be spread over time. ...

What would be the format of the IF/AND/OR nested statement to return the following: If R1 contains a 9 and S1 contains a 36 I want a 4 in T1 If R1 contains...

Dear experts, Jacob Skaria, MVP wrote me a marco below for the solution of conditional formatting on autoshapes. As Jacob's macro refers the value of A1 to...

I have a monthly files where every day is a sheet, the beginning of which references a cell on the sheet before. Is there a way of having this done without...

Apologies if there is a really obvious answer to this but it is driving me mad! When you use the column() function you get the number of the column (i.e....

The cells in column J contains donations made by various individuals. Cells in column R contain certain member classifications. Am looking for a formula...

how do you save an .xlsm file as .xml? the excel files are simple files with cells with no calculations. the records are county property records with some...

AND...I'd be more than happy to pass along the actual worksheet if that would be helpful...