I have a list of about 200 rows with filters. I need to build a graph with series referring to that list but displaying only the 10 first (visible) rows (which...

I download data from a SAP table into an excel spreadsheet (2000), one field of which contains a string...

I want to count occurrences between certain times. I am using the frequency syntax but it doesn't seem to be counting the occurrences correctly.

Hello excellers, I seek a solution for my problem and you are the only ones who can help. I have a year-list of employees for each day ( 100 persons ). Daily...

Hello I am looking for a function that will test 2 parameters, and if neither is true, then default to a specific answer. My spreadsheet has the "F" column...

Greetings, Can anyone tell me how to create a worksheet that pulls information from a web page? I'm trying to update a spread sheet that will pull from...

:( Hi Is it possible to have a perminant Data form when launching excel and is it posible to custom a Data form as you do in Access????? Chris -- Chris...

I am having trouble using the forecast function to forecast sales based on history. The numbers I get don't make sense. Can anyone help?

I am using data in units and dollars by month from this year in an effort to do a quick and dirty sales forecast for next year. I used the units as...

We are currently using a pocket PC with pocket excel to score a large experiment. It is necessary to record the time of day beside each observation. Obviously...

Is there no way around this? I have five numbers I want the average for. But they are not always greater than zero. To avoid DIV/0 errors those numbers have...

When I open a previously created invoice in Excel, it automatically changes the date of the invoice to todays date. I dont want that, I want to see when I...

Hi, I'm hoping someone could please help me. I have a spreadsheet setup which has on one sheet columns of data that represent data for a particular month. The...

I have several columns one is headed TIME and have another column which i would it be an automate entry when i enter the time and the answer would be no if...

I have setup a spreadsheet to keep track of my personal bowling scores. I have made everything automatic except 2 formulas that I cannot figure out, can...

I am trying to group all the numeric data stored in one column. I know how to sort it but I dont know hot wot Group it. Can anyone help me ?

Is there a way to use the "value" of a name in a drop-down list to reference a sheet tab name in a formula? A1 has a drop down list. When a name (Bob's...

JOB # DOC # for that JOB POPULATED 10300-05-2046 100013224 100013224 10300-05-2046 100013225 ...

In using Excel 2003 I am trying to build a schedule, starting backwards and determining due dates based on timeframes, i.e. 6 months from completion date, 3...

I use conditional formatting in excel extensively but cannot figure out how to set it to indicate cells that are blank.