I have a three page workbook and I want every third page to be numbered
sequentially in the upper right hand corner, is there a formula or macro for
this?

Can anyone tell me how I can reduce a social security number to the last four
digits?

I'm trying to get Excel to determine whether x<=y<=z is true or false
but it always comes up false when written this way (even if x=1, y=2
and z=3). I finally ended up with a formula that looked like this
=if((and(a2<=b2,b2<=c2)),d2,b2). This worked, but there must be

I'm trying to count the number of records in one worksheet and return the
results in a different workbook.  The data is held in two different columns.  
I nned to search for all cells where the value is "m" or "c" in D1:D60,
whilst column A1:A60 should contain "*Work*".

How do I delete a rows in Column F if a cell reflects a value of more than
$5,000.
Thanks

I use SUMIF all the time where I check one arguement. How do I write the
formula to check for two arguments? Have checked documentation but am going
in circles - would appreciate any pointers.
Thanks

=COUNTIF(E5:E13,"E") counts the number of staff doing an E (early
shift) as entered in the column E5:E13
I need to count staff doing an "E" (early)  and staff doing an " E ot"
( early shift as overtime)

I have a fairly large spreadsheet. In a particularl section I would like to
sum the values contained in every third cell. Currently I have over 30 cells
I would like to sum and the only way I can find to do so is by referencing
each cell individually with a + sign in front. All ...

pls help me with the formula in excel to add up the cells having only positve
numbers and to skip the cells having a negative numbers.
thank u.

I am trying to use the Lookup formula to lookup information from one column
and match it with information with another.  I then choose a result column to
diplay in my formula field.  what is happening is the number being looked up
is defaulting to a number less than it and giving ...

I have a question Iam not able to find exact answer and my excel skills
are not very high-end
So, I have a Excel document that has Main worksheet and several
(inreasing) number of worksheets, named by customer. I would like to

Trying to build a formula for a tiered commission plan so that the sales
person can calculate commissions based on the number of accounts and
dollar volume of each account on a monthly/yearly basis.
The commission structure:

I have a worksheet with 8 total columns.  Columns five thru eight are laid
out the same as one thru four.  I need to sort the info in columns one and
five in ascending order.  Is there a  way to do this or do I have to cut 5 -
8, paste under 1 - 4, sort, then cut and paste them ...

I am trying to figure out a countif formula.  Here is the explanation:
Worksheet one (my data dump page): In column A I have store names listed.  
In column B I have the amount of each sale for that store.  
Worksheet two: In column A I have the store names listed.  In column B I

Does anyone know if you can change the font or shading of a cell by rolling
the mouse over it?  I have a worksheet where the user has to make several
choices.  I would like each choice to stand out when they roll the mouse over
it.  What do you think?