I have 2 tabs. One spread sheet is a summury of the other.
Each line item on one tab goes across. The other tab goes down.( every line
on Tab 1 is equal to 10 lines on tab 2 )
Tab one : XX    XXX     XXXXX

I have got a problem with an If Statement that I am trying to create.
Cell A1 is a variable number (but I will use -24, for the example)
A3 = -9
A4 = -15

When I imported lists from Outlook into an excel spreadsheet, the data for
the "email" column imported not only the email address, but unwanted info as
well
example:

I am trying to figure out the best way to calculate a year to date total in a
particular spreadsheet.  Here is an example of what it looks like
Number of months        4                   
        1    2    3    4    5    6

When I insert the NOW function in my worksheet, it updates whenever I open
it.  I only want the function to work when I hit "save" or update a cell in
the worksheet, so that the date/time indicate the last time someone
reviewed/changed it, not the last time it was simply opened.

I am having trouble with the VLOOKUP function.  On a separate sheet, I have
all my Part Numbers listed with the associated information. Some of my part
numbers contain letters, such as 21112471L, and others are just numbers.  
Therefore, there is no logical sorting going on in my ...

I need ot create a dependent list where a user can select multiple options
from the dependent list.  example, when a state is selected, the dependent
list displays teh corresponding county list for the state selected. Ithe
users needs to select, one, all or multiple counties ...

I'd simply like to sum the first n values in a column or row, where the value
of n is in a separate cell. ie if I enter '3', it will sum only the first
three values in the range, if I enter '8' it will return the sum of the first
8 values in the range. TIA for any help

I posted this question once today in the general Excel group, but am
reposting here just in case someone might have some info.  Sorry if you read
this already.  I tried to cross-post here and it didnt work originally...
I am wondering if anyone knows, is there a way to format a ...

I have to type in the calculations with in Parenthesis in this project that
looks like the following
e. The volunteer's tax knowledge               
Excellent    80%    77% (-3)     76% (-4)     75% (-5)

I would like to find the row number of a cell based on it contents. In
other words, search a column for a particular value and then find the
row number.
Is there an easy way to do this?

I am using the following SUMPRODUCT Formula:
=SUMPRODUCT(--(Data=InputCell_DB)*(SUBTOTAL(103,OFFSET(INDEX(Data,1,1),ROW
(Data)-MIN(ROW(Data)),InputCell-1,,))))
to return a summed count of a varying criteria; row 1 = the formula, row 2 =

I have a column that contains lots of post codes.
E.g
EH48 3SS
EH48 3HU

Is there any way of creating bullet points (as in Word) within cells in
Excel?
Sometimes I find it useful to separate comments within a cell and wonder
whether there is a way of doing this other than simply typing the '-' key

same information about this founction, please!