I have a very simple table that I would love to insert a number that will
multiply the current number then average the whole table.  I am sure it is
simple, just a bit beyond me.  The table has Col B with letters  Col C are
the numbers that correspond Col D I would like to put in ...

I need to pull the last character from the data in a text field.  Problem is,
the data is not all the same length.  Sample data:
BBD2
BPN10499B

I am trying to copy a workbook from one worksheet to another.  The workbook
contains cells with input ranges referencing a workbook within the original
worksheet.  When I copy or move to the second worksheet the Input Range
formula changes

I am trying to add any changes to E4 to F4 as a running total. I want F4 to
keep adding to itself any thing put in E4.
Thanks for any help with this.
Tray

I am working with the excel MOD function.
MOD(n,d)
n = 2929.68750000
d = 418.5267857

Hey All,
I'm trying to restrict the Web Page Preview command similar to the
restriction of the print command but I'm having a hard time figuring
out the macro to get this to work. Any help would be greatly

I would like to extract the row number in a reference formula
formula in cell "= Bef22022007!F293"
How can I extract the 293?
Thanks

I need to create a function that will display an error if the sum of a range
of cells subtracted from another cell does not equal 0.  I figure the first
part is
=SUM((J12:M12)-I12) that should total 0 and if it does not I need error to

I have a list of records that have many duplicates. I need a formula that I
can use in the adjacent column to show a 1 for the first instance of a
duplicate and a 0 for any others.  The list is sorted so all dupes are
together.

Is there a way to use the Count if function to count if a value is between 25
and 40?
Using Excel 2003

I have this if statement and when I go to add 2 more if statements I get an
error.  Can you help?  Any help will be greatly appreciated.  Thank you
=IF(C6="15764",'MA RUGS'!J10,IF(C6="14484",'MA RUGS'!I10,IF(C6="99922",'MA
RUGS'!L10,IF(C6="39300",'MA RUGS'!I10,IF(C6="49340",'MA

Column A is Date ie. 2-Feb-2007
Column C is # of items
and Column E is Accuracy .ie 97.13%
I need to multiply every item selected by its accuracy then add them and

show with example how to change a number of 1 cell into a text form in the
another cell ?

When ising cell validating with a list, I want the color of the cell to also
change per each item on the list assigned to the cell.  Also, I want to
incorporate the data into the cell itself so that I do not have source data.  
How do I do that?

I have a cell on worksheet A that includes a data validation list in cell c4.
The data validation list is a list of named ranges from other
worksheets--one range to one sheet.
I want to write a formula referencing the range name in cell C4 to go to a