I have FrontPage email me the result of a survey form -- with both the
question and the response. If the person selects a particular question the
result is "1". However, when I copy and paste the emailed results into Excel
the "1" is preceded by several spaces so that I cannot ...

i have two list of names of 500 to 1000 in size that are in two different
columns. I would like to generate a new column with names that are only
present in both list of names.  help. thanks

I have a worksheet that has a drop down list in almost every column that
allows you to filter endlessly.  there used to be something..  a formula?  
that would count the number of entries based on the filter from the drop down
list.  someone deleted the cell and now I can't figure ...

Hi.  I have the following formula in my spreadsheet that I need some help with:
=ROUND(AVERAGE(IF((Damian!$N$4:$N$10000=""),Damian!$P$4:$P$10000)),0)
Cells N4 through N10000 contain either a blank cell or an E or an I.  Cells
P4 through P10000 contain a calculated number.  The ...

Dumb question for you.   But I am trying to find the right formula for this
problem.  What i want is to add column D3 to D38.  I want to find aveage of
all the $ amounts and divide it by how many people their are.  I have d3 to
d38 as dollar amount and them find the total aveage. ...

I have a worksheet with 3 columns. Some numbers are like. 2450.00. Some are
7.47 and some are 125.69. I have the columns formatted for 2 places. Is there
anyway to simply enter a number in a specific column and not have to enter
the decimal while entering the number and have it ...

I have a list of 12,000 rows separated into two columns.  In each row, the
two columns either match or don't.  So I've made a third column that is just
a simple "if" function in each row that puts a "1" in if the two columns
differ.  I then use a "countif" at the bottom to tally ...

I am downloading banking inofrmation to a spreadsheet. It downloads as a
negitive value. Is there a way to automaticly change this?

I would like to be able to enter a date numerically and have Excel formatt it
with the slashes, ie;  fromatt 092207, to 09/22/07.  I don't want to have to
enter the slashes just the numeric value.  How do I do this?

I have a cell reference in a cell to a seperate sheet (e.g. =sheet2!c2) which
contains a simple addition formula (g1+g2+g3).  The problem is that the
totals are not automatically updating in the cell reference cell when there
are changes in the sum sheet (g1_g2+g3+g4).  I have to ...

I'm trying to create a spreadsheet that will help log eBay sales. I want to
set up a formula to figure the fees once an item is sold. I'm hoping to just
enter the final sale price and in another cell with the formula in it, figure
the eBay Final Value Fees. I've tried a bunch of ...

When I type a formula in my spreadsheet it appears as the text of the formula
but not as the calculated value.  Can anyone help?

In my spreadsheet, I would like to find all the "and" words and then
CAPITALIZE the very next letter or word in the same cell.
Thanks!

How can I count the number of characters in  a cell?

Im am trying to calculate the following. What is the best way to do it.
if C2 <> C1                                (value of prev row same col)
  and if D2="O" or "B" then F2= 1                (numeric result)
else if C2 = C1                            (value of prev row same col)