I'm performing calculations on market data during specific times. (1000AM to 1130AM and 1330PM to 1500PM) Can I include both AND and OR in my function, or can...

I have the following partial spreadsheet: Date Total Hours Compensation 1/15/2008 11.00 $133.43 1/22/2008 12.15 ...

I have a list of data (about 19000 rows/data values) with water quality values at 53 locations ranging from March, 1979 through March, 2003. Some months...

Previously... I had in issue which was resolved by using the following. Dates in the range D1:J1 Usage amounts in the range D2:J2 Stock on hand in C2 Entered...

I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I...

I am not sure what to do here. I have a worksheet and if C29 - C26 =0, I want the cell to dispay the amount (for example 20000 - 15000= 50000) but if it is...

I am trying to set up a growing list with one column of numerical data that gets totaled at the bottom. Any new data must not let the total go below -2. ...

I am working on a spreadsheet which has many different fields. The first column is Last Name and the second column is first name. My objective is to delete...

Hi I wonder if anyone can help me with the following problem. I have two tabs within a worksheet. The second has a number of colums including those shown...

Hey there, I'm trying to do the following: ColB contains either 1,2, or 3 ColC contains a combination of 12,21,23,32,13 or 31 What I'm looking is in ColD, to...

In the following "sumproduct" function, what do the "--" mean? =SUMPRODUCT(--('Evaluation Detail'!$B$7:$B$4990),--('Evaluation Detail'!$F$7:$F$499="Jane...

I have the following in my spreadsheet (I hope you can see the layout?): A B C D 1 Counterparty Price ...

How do I get what % increase is between column a and column b?

I have an excel 2003 workbook with several worksheets - each a mirror image of the others i.e. any particular cell has the same data (not literally) Cell B6...

I would like to perform a rank calculation such as the following: = RANK(AB3,(AB$3:AB$358,'May 2008'!AB$3:AB$358,'April 2008'!AB$3:AB$358)) But it is...

I have a work sheet in which column A is having "Recd On" (Date). column B is having "Dispatch On" (Date). If there is no holiday Dispatch On date = Recd On...

Hi. I have a table where I have to select the lowest price in each row for several options (suppliers). e.g. I have values in columns J, O, R, U, X from row...

I have a document that is a fill in that I have protected the document and have only certain cells that are available to enter data into. It is setup so...

Hi! I have a File.xls. I would like delete it but when I try, return the message: File.xls is locked for editing by 'an'. How is possible delete it,...

I have a date and want to know in what period this is. Reference ranges: period begin end jan 1/1/2008 14/1/2008 feb 15/1/2008 ...