When a value is entered into a cell, you can move to the cell beneath it and
start to type the same value. Excel will recognize the value being similar
and populate the new cell with the old value. However, I find there is no
consistancy with it. Some values it works with and ...

Can anybody please tell me how I extract data that matches the following:
Need to extract the sum of sales that are in a column that matches certain
criteria.
I have a column with products that are sold by certain companys.  Some sell

I've created an IF statement with multiple formulas, but I can't seem to
figure out if it is possible to pull the information by a specific date
range.  I have sales reps that visit customers on specific dates and I need
my tally sheet to only pull dates within that current week. ...

I want to enter a letter in a cell then trim any spaces from the text and
convert it to lower case.
Can I do this by using functions in the cell where I enter the text?  I'm
developing a spreadsheet to be used by Pocket Excel so I need to use

I have 2 sheets in a work book ( sheet one referring to Sheet 2) I need to
hide sheet 2. How?
Thanks
ce

=IF(ISNA(VLOOKUP(B2,'TableB'!$Y$2:$Y$100,1,FALSE)) , "",Column A in
tableB)
This is the code i have.
I want to search tru all column B in table A. If i find an identical

Hi, does anyone know if you can make the check box in the forms tool bar
bold? Or if there is any way to make it stand out more when printed?
Basically, is it customizable at all?

I have a spreadsheet that was sent to me that I need to subtotal a row.
When I use the subtotal icon I get the formula but not the result.

I am trying to extract last names out of a list of doctors formated as
first name, last name, then MD.  I am trying to use the find function
to count the characters up to the space between the names using =FIND("
",A1) but I get a value error.  Is there any way to find the position

I have tried setting a COUNTA formula on an array. The cells in the array
all have a similar formula in each one and will contain text if a specific
condition is met in another set of cells. The problem I am getting is that
when I put in the formula =COUNTA(A1,B1,C1), I get the ...

There should be an option or formula that you can run on excel to find all
duplicated line items for example:
Line 1 has John Doe
Line 2 has John Doe

If I put numbers 1,2,3,4 in a named range "x' in cells a1,a2,a3,a4 and put
SUM(x) in any other cell I get "10" as output, thus correct answer. If I
change the formula to "SUM(x^2) I get "1" instead of "30". However when I use
the function wizard by clicking on "fx" at the top of ...

hi everyone I want to write a sub that converts all values of two
consecutive columns(C1:D190) from c degree to f degree.I know the
formula but don't know how to apply it to all cells I'm completely
confused .This is part of my school project and I don't know how to do

Im sure theres a simple answer to this but Im having problems with a formula.
My formula is as follows -
=(D33+E33)-(S33+T33)/(D33+E33)
Essentially the sum of D33 & E33 is 19, the sum of S33+T33 is 7 giving me

I have a worksheet that I am trying to create a formula for.  What I want is
once a certain cell has text in it, the next cell populates with the date the
first cell was entered.  I figured that part out by using a combination of
the "IF" formula and the "NOW" formula.  But after ...