I need to interpolate  results from an experiment. What a simple way to do it?
Here is the data I need to interpolate. (EX: 1.3439 and 1.3495 in intervals
of .05. Thank you
1.3439        10

My spreadsheet has many worksheets (tabs) labelled like (e.g.)
61900003.
There is also a Summary worksheet with a column (D) containing all
those worksheet names. In an adjoining column (E) I wish to enter a

Here is what I have
Col A     Col B            Col C
1310    3    3,463.00
1315    3    740

I am moving info using the LARGE 1, LARGE 2, LARGE 3, LARGE 4. I need the info
sorted in groups of 4. I put the formula in the first cell, A3,
=LARGE(jan!$AA$54:$AA$57,1). When I copy it down the 1 on the end of
the formula stays 1. Then I have manually go back and change to 2,3,4.

Anyone can advise how to set the default format for remarks inserted to cells
in Excel?
Thanks.

Illustrative example of my problem:
I have a list of numbers and letters.  How can I lookup the value " 1 " and
return the multiple results of z, a, g ?    I want to type only one formula
in one cell, although I don't mind the result being spread out over multiple

Have a large spreadsheet with 1 column I want to monitor changes in on a
monthly basis. (In a separate sheet, i setup TRACK report to monitor monthly
changes for this one column)
This column is now empty. If I added data into 5 of the rows in jan, and 6

when autofiltering the spreadsheet it doesn't calculate from how many record
it found how many record like a normal auto filter does.

I have the following Sumif formula, which works fine.
=SUMIF('South Central'!E:E,summary!$C$1,'South Central'!B:B)
Is it possible to reference a cell that has South Central typed and the
formula use the sheet name and still work properly?  I have a large

Hi,
Here is an illustrative example of my problem:
I have a list of numbers and letters. How can I lookup the value " 1 " and
return the multiple results of z, a, g ? I want to type only one formula

I need to calculate the total WORK-hours (08:00-17:00) between two
date/time-stamps;
-excluding WEEKENDS
-excluding PUBLIC HOLIDAYS

I'm looking for a formula that returns number of items delivered on time.
Ex: How many items "Apple" were delivered on time in the table below.
    A    B        C
    Item    Requested    Delivered

I am trying to compare each cell to the one below and this for a whole range.
The difficulty comes form the fact that I need to have an alert in one
formula.
Something like

Hello I have a worksheet that I need to find the value of cells greater than
4.5 i have tried =AVERAGE(IF(A1:A30>=4.5,A1:A30)) and it works but i only
need certain cells for example i only need cells A1,A2,A3,A4,A10,A23,A34 but
only if they are >4.5 what is the formula?

How do you vonvert hours, minutes, seconds (129:39:00) to hours?