I am trying to find or match a value from one sheet in another sheet.
So for example
The formula would look at the value in cell A1 Sheet 1 and look for the
value in $A$1:$A$50 Sheet 2.  If it finds it, then it would return a

I am looking for a way to freeze a row so that it stays on the top of the
worksheet as I scroll down.

Is there any way to use a function like this:
=OFFSET(MAX(A2:E2),1,2,1,1)
the goal is to find the first 3 bigger values in a row and return them
with the title of the column.

In a test procedure, I end up with a column where I use CountIf to determine
if there are any F (for Fail) characters in the column [=If((CountIf(M25:M95,
"F")=0
("Pass Msg","Fail Msg")).   This works OK.

I need to lookup values in an array, but my data is not sorted in any order.
We use unique identifiers but they are not always in any kind of order, and
it would not be useful to us to use them in ascending or descending order.
How can I lookup the "Original Body Text" in one ...

Hey all, I've tried a while to get this working. SUMIF() is where I wa
trying. No dice though
Image of the spreadsheet:
http://www.icoholic.com/pics/exceltroubles.jpg

I have a spreadsheet with a series of drop down boxes with multiple values.  
Is it possible to set up a formula that will add only those cells adjacent to
certain values?  As an example, if the drop down has options such as PENDING
and CLOSED but I want to have the system ...

I want to make a clickable button to do a time stamp Key Combo of
"Ctrl"+"Shift"+";".
Using Excel 2003

k2-k20 is a range of numbers
E2-E20 include X as a name
I'm attempting to count all the instances in which x exist between 382 and
383 in the k colum.

How can I make  a template that have cash + account receivable +supplies +
office equipment = notes payable =account payable = common stock + retained
earning

I am an accountant and we use a amortization program called Tvaule.  
was wonder if there is a fucntion that does the same.  For instance, I
I wanted to get the loan amount for the following....
Payment 7208.78

I am writing from Germany so sorry for my bad English!
I have got following problem: I want to change a value of a cell fro
the minimum to the maximum in defined steps. For example: I know, tha
the value varies form 5 to 10, I want to say ecel "change it in step

I have looked everywhere for help.  This should be a simple formula,
but never works for me.  I have a main worksheet that I entered dated
data into.  I want another spreadsheet to pull data specific to my
criteria.  Basically I'm trying to pull If Cell A:1  is greater than or

I have data in column A, 14 digit number; by cutting and pasting from another
data collection file place a smaller amount of data in column B also 14 digit
numbers; have to find those numbers in A that are also on B column and delete
the record.

I'm trying to do a VLOOKUP from two different sheets on a another workbook.
Can a person combine say for instance a logical function like OR together
with VLOOKUP?
E.g.