Have a data range containing headers on the first row and numbers below. When I create a subtotal, Excel inserts the subtotal() function. The grandtotal line...

I'm having problems retrieving stock quotes. I'm following the directions (typing symbol in cell in all caps, then clicking outside the cell), but only...

Hello from Steved I have an index in Columns which has a Label the cell below has a Label and below that a Constant. The index is C4:AT125 In A1 and A2 I type...

Dear all, Suppose i have a workbook containing a worksheet, whose cells r linked to another a worksheet in another workbook. now the problem is, i want...

I can't use the formula below because this data links to several different graphs and charts. If there are blanks, it still shows in the graphs. Don't know...

Assuming the data is in A2:B6 (with row 1 = col headers) col A = team name, col B = startdates Put in F1: =SUMPRODUCT(($A$2:$A$6=D1)*($B$2:$B$6=E1)) where in...

You can use: =SUMPRODUCT((Team="TeamA")*(StartDate=20031004)) -----Original Message----- Hi, I am trying to count the number of times a specific...

Hi all, new to forum and found it by being totally stuck :P Basically, I've got some information for example: (A) (B) (C) Date ...

Is it possible in Excel 97 for Windows to format a worksheet so that, for example, columns A-F print on the top half of a page, and columsn G-Z print...

I work with Excel several hours every day. The default number formatting ("General") is not one that I EVER use. But I can't see a way to change the default...

First of all thank you for replying to my e-mail. As per your request I will give you more details on what I want to do. Every day I pass the rates of...

Hello, I am working with order forms for different types of equipment, each having its own worksheet. After selecting the appropriate sheet, I then want the...

I would to know if anyone could answer a question for me? I am using Excel 2000 with XP Operating System. When I set up a spread sheet and adjust my cells for...

Hi, I'm using Office XP now and I store images in my Access database with a OLE object data type field. Now I wish to display the image binary data (retrieve...

Have a data table consisting of 36 columns and rows that vary in quantity from 13000 to 19000 rows. From this table, there are 3 pivot tables to give you the...

Hi, I am trying to count the number of times a specific date value occurs for a specific team. Basically, column A "Team" contains multiple entries of a team...