What formula can I use to fill in cell I7 with a value from a list (in column
L) using another list (in column K).
The scenario: I have a list of prices (column L) associated with a list of
descriptions (column k) and want to be able to pick a description in a

How can I sort cells with letters and numbers, and the numerical digits have
different place values.  For instance here is a simple list without decimals,
AA21, AA100, AA1, AA2.  Is there a formula or macro that will sort the cells
as AA1, AA2, AA2, AA21, AA100?

Excellers;
is there any function to do this?
Transpose and copy data from sheet1! from c8..f8; C144..F144,
C277..F277, C410..F410, C545..F545, C680..F680, C815..F815

I am looking for a formula that will average a row of cells.
The problem I am facing is that all the cells that require averaging may at
different times have a different amounts of lines in the equation.
i.e

Need conditional formula to turn the numbers columns a different color for
each set of initials.  All numbers where the initals in Column 2 are BS
should be blue in Column 1, SH should be pink. etc.
Col. 1      Col.2

Hello from Steved
1st argument = $25000
2nd Argument = Sum: $24000
My Attempt =sum ($25000-Sum: $24000)

I have created a userform to move data to a worksheet. I also want to add
some buttons to insert an X in a text block to identify the use or outcome.  
click a button and an X appears on the worksheet.  But only one of the five
buttons at a time.

I need a formula to shows hours between dates.
Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

Forgive me for the lack of excel termonology I know, I just use the program
I have had much success with Conditional Formatting when it involves
numbers, formulas, and the like.  However the current task leaves me in a
quandry.

I have read all the posts on sumproduct and have finally managed to get the
formula to work. What I was doing wrong was asking the answer to be placed on
a different worksheet from the table it was pulling information from. Is
there any way to create a formula that will put the ...

Ok, first post here so take it easy on me. I am trying to auto hide
rows on a worksheet, unless there are values in rows on another
worksheet in the same excel document. For example, if Sheet 2, row 10
has a value in column A, B or C, then I want Sheet 1 to show those

I have a formula to turn minutes in to hours and a decimal ex. 155/60=2.58.
However, I need to turn the .58 into .35. Does anyone know of a formula that
might make this possiable?

Using XL2000, I have 12 identical workbooks, one per case worker.  Each of
these workbooks tracks the types of incidents the case workers deal with.  
The types of incidents are standard across all workbooks.
These 12 workbooks roll-up into a summary workbook for the supervisor.  ...

I have such worksheet.
A        B
3        1
2        2

is there a way to formulate the following.
IF A2 = whole number then enter 0 if A2 contains a decimal than enter
content of B4.
whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect