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

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 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...

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...

A B C E F 1 SKU SUM SKU SUM 2 85 10 85 10 3 86 20 86 20 4 87 30 88 30 5 89 40 I'm trying to make a formula that can tell me the sum of each number....

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

Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael

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...

Hello, I'm using the following Vlookup formula: =IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment Support\Dummies2Live\2010\May...

I have a 2 sheet workbook. If cell 'sheet1 b7' has a certain word typed into it I want 'sheet2 b2' to return the value in 'sheet 1 b8'. Can I do this?...

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...

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...

we are attempting to create a Cash Statement report for a single account and would like to include a To Date, Month To Date and Fiscal Year totals. Is there...

I am trying to classify people into age groups in Excel based on their DOB. U8 1-Jan-2003 to 31-Dec-2006 U10 1-Jan-2001 to 31-Dec-2002 U12 1-Jan-1999 to...

I have a matrix of data that lists part numbers in row and serial numbers in column as shown in Example 1. In the example below (Example 1), the range...

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...

I have a list of number: -17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3 The sum of those number +1 is the answer to the current number, but what...

I want to convert a spreadsheet that has 9 fields into a block of text. From this in Line 1 in an excel file (9 fields): 300 Shady Grove 15720 Shady Grove...

I am currently using 2007 - I have about 20,000 rows by 12 columns of information in a spreadsheet. Column "G" cells will at times have more than 1 number in...

I have spreadsheets that have multiple cells with color backgrounds. The cells vary on each sheet. Is there anyway to print the spreadsheets with the color...