Approximating a curve
I have a set of X and Y values for example
X    Y
690    0.82

I have three columns of data which I would like to get into a table.
I cant use a pivot table as each column is alpha none are numeric What I am
after is some kind of look up function that would look up both the column
heading in column 1 and row title in column 2 and then return ...

Howdy...
Here's my question...
I'm attempting to sum a row of #'s MINUS the lowest value.  In my
spreadsheet the lowest value could be a text character (NP) OR it could be a

After I copy how do I stop the lines from outlining the selected cells
have copied
--
Columbia

Howdy All,
Here is what I have:
Box inventory worksheet:
Column A = Box number

when I try and auto resize a row it often will not exand to the correct size
allowing me to read all of the text.  When I manually do it it will stay for
a while and then days down the road I come back and it has somehow reverted
back to the orriginal size that does not allow me ...

(A2)=IF(ISNUMBER(SEARCH("n",W2)),"Y")
THIS WILL PUT A "Y" IN CELL A2 IF THERE IN AN "n" (upper or lower case) in
cell W2.
I need it to put a Y in cell AS only if there is a lower case n in cell W2.

I used multiple IF statements to return a number from 0 to 8.  I now need to
sum the results of the returned numbers in a row.  When I use =Sum(A7:J7) it
returns 0.  How do I get a total on this Row?
Copy of statement

Help!  The current formula is listed below and works just fine.  However, I
have altered our worksheet and now have 15 options instead of just 7.  Where
do I go from here if I can't nest any further than this.  I've used VLOOKUP
in the past but can't seem to get a grasp on how to ...

I have a Conditional Sum that is used extensively through multipe sheets to
slice and dice a fair amount of raw data. The ending row (17424) changes each
month.  The references to row 17424 is calculated in another cell ($L$3)
using the MATCH function. I would like to substitute ...

I have a 2 command buttons on my worksheet named "-" and "+".  If the a given
cell value is either zero or blank and I click on the "+button" it must
increment the value  by 1 and if I click the "-button" it must subtract 1
from the value in the same cell. Your help is ...

ok, iM trying to figure out a formula that calculates time..
Im working in construction domain and there is what i wanna do on my sheet..
i have cell that eqals the hours work during the day.. so .. C4 is the time
of beginning, C5 the time of ending, D1 is the time of dinner that i ...

I am using Excel to work out wages, and i have my excel set up so that i can
see all months from January to now in different "sheets". What i would like
it to be able to do is, that i would like to be able to put an extra section
in, so that on each pay check, people will be able ...

I have frequently used an array formula to compare to lists and to tag
entries that appear on both lists which I originally got from Chip Pearsons
site.  The formula is =IF(COUUNTIF($A$1:$A$10,B1)>0,"On Other List","").  
However, I have now been asked to compare two lists and ...

In summation, here is what I need!!
if ANY fails exist, then read Fail
if ANY blanks exist, then read blank
if ALL entries = pass, then read pass.