I have a spreadsheet that is filled by experimental data.  The number of data
points (rows) can be 300-6000.  I am tasked to take 50 point averages at the
25% and 75% points of the data.  I can get the number of data points using
using the COUNTIF function.  I need to be able to ...

I am trying to write a formula to return a cell if zero is listed.
My example is
CURRENT MONTH        4776
JAN        4308

I have used the formula =PROPER() with the cell reference of the first name
in uppercase in my list A2. When I double click on the fill handle at the
bottom left corner of the cell, instead of changing the names to proper case,
it merely copies the value in the first cell - so if ...

I have a spreadsheet containing 6 cells say with the following values ...
1 2 3 1 2 3
I want to work out the MODE and if there isn't one, then work out an
average, but the problem is if there is no mode it displays the first cell

Cell W3= Smith, Joseph
=LEFT(W3,FIND(" ",W3)-1) gives me the left text including “,”.
=RIGHT(W3,LEN(W3)-FIND(" ",W3,1)) gives me the last word in the string.
The end result I’m trying to get is “Smith, J”

Could anyone tell me if it is possable to copy names from one book to another
book.
ie. I have berwick,bastille ,challange ect in one work book in seperate rows
and these will keep coming up again in the same workbook and I want to copy

I have some formattings and formulas on cells of each row and I have an open
spreadsheet that can be updated by a few peoples.  If someone wants to add
rows, how can the formats and formulas be retained automatically.  Your
guidance is appreciated.

I need to format the background color of the cell according to the score.
Is there any function to serve this purpose?  Your guidance is appreciated.
Thanks,
Ray

I have a work sheet (invoice) that I would like to use to calculate hours on
various projects.  I have a time-in, and time-out column.  I would like to
calculate hours spent.  My formula returns the time in hrs and min.  I would
like just hrs.

Is thre an easy way to set up the following testing conditions:
- if A1=A2=A3= ... =A10, do something
??
Thanks!

Does anyone know of a plugin to compute mileage between two points in EXCEL
2002?  I do audits and must travel to many different sites.  I'd like to use
a spreadsheet to keep up with expenses including mileage between office and
the audit sites.  I've looked at Mapquest, but ...

How can i re-arrange a list of text (which are names) in such a way: for
example changing
Bob Smith
to:

I import data into an Excel spreadsheet.
If I go to the end of the spreasheet (by pressing CTRL End) I am on line 5,000
I then delete approx. 500 lines.
The end of my data is now on line 4,500, but when I press CTRL End it still

I'm trying to set up a workbook for a friend that uses the SUMPRODUCT
function in order to count by two different criteria. It's working
wonderfully except for this tiny problem - One of the things I've asked
it to look for is the word "Passed" in one of the columns which works,

I have a table that looks like the example below.
There are several of these tanks with input data on each sheet and there are
12 sheets in the workbook. I want to make a page where I calculate the
average of all the input data, irrespective of which tank the data comes