I have the following PSD data. In addition to the largest number less or
equal to the lookup value I would like lookup to also give me the smallest
value larger than or equal the lookup value on another cell
Size (mm)    % Passing

I have the following PSD data. In addition to the largest number less or
equal to the lookup value I would like lookup to also give me the smallest
value larger than or equal the lookup value on another cell. I would like
Lookup to give me the Size passed by 80 percent or less ...

here is a simple formula....
=A1+2...... this assumes the cell ur looking at is A3
i want the lookup to happen from another worksheet.
eg

SUMPRODUCT(--(DATA!$C$2:$C$1500=98366), DATA!$AB$2:$AB$1500)
This is what I have been trying to use. What I am doing is looking for a
specific zip code in one column when I find it I want the value of another
column to be added to a total.

I am using VB to manipulate the excel.
How can I get the cell(e.g. "AB4", column AB and Row4) if I want  to shift
25 columns to right from "F4" cell.
What the formula should be in VB or excel?

Please can anyone point me to the best way to do this, I expect it's a
common problem and my head is spinning trying to work out the simple formula
needed:
I have a sheet with  rows  showing tasks in  a project, each task has

In a spreadsheet using about 20 columns, after entering a letter in Column C
or just pressing Enter, I need to jump from Column C to Column E. It has been
brought to my attention that I need to create a Macro for this function, but
unfortunately I cannot find one that works. I think ...

I was provided this formula to not look for the word Repair Clin:
=IF(O31="","",IF(AND(TRIM(B31)<>"Closed",NOT(ISNUMBER(SEARCH("Repair
Clin",S31)))), O31+ROW()/10^10,""))
Now, I need the opposite.  I want it to look for the word Warranty item.

Hi!!
I'm trying to break up a string into sub sections. Eg 1 cat, 2 dogs, 66
chickens...
So far I have managed to get the first number out, but to get the dog count

I have the formula "=A1*Z1."  I would like to copy and paste this formula to
several cells starting with the first cell down.  I would like the next cell
down to be "=A2*Z1" and the next one "=A3*Z1," etc.  Instead what I get is
"=A2*Z2" and the next one "=A3*Z3," etc.  Is there ...

I have a large document that contains thousands of email addresses.  I want
to delete the part that becomes before the "@" sign, inlcuding the "@" sign
across the whole spreadsheet.  EG: kendraa@ecollege.com becomes ecollege.com
only.  How can I do that?

I am using the IF function for a range of cells and trying to get an error
alert to pop up when incorrect data is entered. I have been following all the
steps I need to take, but it doesn't seem to work. The cell referred to does
show error, but the opo up does not appear.

When should I use STDev and when should I use STDevP.?
I get the basic idea of Standard Deviation but I don't understand the
differences between the two functions.
Could anyone help explain the differences?

I use this formula:
=SUMPRODUCT(--(Sheet1!$Y$4:$Y$903=Sheet2!G$10);--(Sheet1!$AB$4:$AB$903="Directed");--(Sheet1!$I$4:$I$903=Sheet2!E11);--(Sheet1!$AC$4:$AC$903=60);Sheet1!$N$4:$N$903)
The values in Col N are not numbers. The formula returns 0 (zero).
Is there a way to modify the ...

Hi..there
If you have any clue, please help me out.
I have the values in A column below
A