I'm working with excel 2003.  I received a spread sheet via email.    There
are several colums adding up to a total.  I want to do is take the total
column and the vendor name and move them to a new workbook.   when I copy and
paste,  the information will not transfer because of ...

Can't get the formulas I used in Quatro Pro to calculate in Excel: circular
reference that wasn't abated by changing iterations.  Having a senior moment
and can't identify what I'm missing.  Formulas shown below.  Be grateful for
any input.  Thanks.

I have the following data in 3 columns
A    B    C
TOP    BULB    1
TOP    SCREW    5

I am trying to find duplicate entries (text) in a single column without
sorting.  The column is several hundred rows in length. Can someone help?

I am using Goak Seek in a macro to calculate the interest rate needed on a
cash flow to hit a known amount. Below shows the problem I'm having in some
of the 60 columns I'm using. Evetually this will be 121 columns.
In each year I need to find the ROR such that the sum of each ...

Currently I am trying to get Count of Certain numbers in column which has
numbers as well as text. I have data which is very uneven e.g 4 number then
followed by text "Total" then again 5 numbers followed by text "Total" I need
to have Count of numbers field for each category ...

I am collecting data for a salt bath temperature comparison.  There are three
readings from the salt bath (controller, high and low) and 3 readings from a
test sensor.  The test sensor readings are subtracted from the bath readings
and the results are listed in cells J4, K4 and ...

HI ALL , and a good day
I have a very big need !    I have this
combined function    :
=AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D1;D3;D5)<=1;COUNT(E1;E3;E5)<=1;COUNT(F1;F3;F5)<=1)

I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?

I am at my wits ends trying to do some excel magic so after days
trying to figure this out myself I have turned to here in
desperation.. I am hoping someone can tell me if I am on the right
track or point me in the right direction.

Does anyone know how to convert numbers that get imported as percentages
converted to whole numbers?  
Ex. 100% to 100, 80% to 80
Thansk for any help.

I received this strange problem:
On sheet 02-E14-4 in an Excel fie, the cell M23 contains the value 0,500.
On another sheet (Récap2008) cell I83 contains this formula:
='02-E14-4'!M$23. BUT: the value it shows is 0,250 instead of 0,500.

In a cell, I often want to reference another cell and want to return
"No value" or have it remain Blank, but the cell that I am referencing
has a formula, so ISBLANK does not interpret that the referenced Cell
is Blank.  What formula can I use to return no value or leave the cell

I'm trying to figure out the best way to use advanced criterea in formulas.  
Here's my example:
Date              Account             Amount
1/1/08           account a           -$5

Please can you help!  I am trying to calculate from a list of dates,
which calender Period the date falls into.
I have a table in excel with period number in first col1, period start
date in col2, period end date in col3.