How can I make it so Excel checks a column to see if the are an exact set of
entries in a column, in no particular order, and with empty cells. I'm doing
a schedule, and none of the templates I've found work for me. Each column
represents either a day or night shift, and I need ...

I'm trying to get the vacation time for my store, which accrues at a rate of
.22 hr per day, to calculate and auttomatically adjust each day. How do i
write out the formula using the =Day() function* or the =NOW() function*? Or
is there a better way to express this?

I have a web query which gives me the result "385/1700" and all I want is the
first part "385" to allow me to do calculations with, but because it's a web
query, it wont let me just format it as a fraction and times it by 1700.. it
comes up with the #VALUE! error.

I am making a spreadsheet for upcoming training and it due dates.  i am
trying to set it up where when training is complete you enter the date and
time, and then when it comes withing 3 month of being due again it changes
color, and then at one month it changes again.  I am ...

cDear All,
I have following question:
suppse I have cells where I wrote revisions of some documents eg : 01, 02,
03, but suppose some "02"s or some "01" or some "03" are latest revisions of

Hi I would like a formula in a cell where I can show the sheet name.
For example
="2008 "&"Sheetname"
Anybody who knows?

The conditional formatting & other examples I've seen don't quite give me
enough options - we are using Excel for project-like lists (because, unlike
Project, it can slice, dice, count according to various strategic
parameters).  For those projects, besides metrics & tasks, dates ...

I am trying to setup an excel file where I can allow users to input data to a
form that I created.  I want them to be able to input data and save it, but I
do not want them to have the ability to delete anything on it.  I am having
problems trying to setup the permissions on the ...

i am making a spreadsheet to track training.  I put in completed dates and
when they come within 90 days of being due i want the cell to turn orange,
and when they are within or past 30 days turn red. the rest of the time i
want them all green.

I'm not sure if it matters, but mainly I am asking for Office 2007.
I'd like to know if it's possible to refer to a cell, in the following manner:
Assume I would like to refer to cell A8, so normally I would simply type:
=A8

I need to put a logo on my first page that requires a large header margin,
this ends up leaving a large blank space on the following pages. I know how
to do this in word but can not figure it out in excel.
Thanks for the help

I have three cells in a row:
cell1= table
cell2=,
cell3=book

I have a Quatropro formula @LASTCELLVALUE(name:$B$5...$B$87) which pulls the
last values in a column from a sheet to a summary spreadsheet.  I have been
unable to find an equivalent Excel formula.
Any suggestions, Thanks!

One of your pivot table cubes has started acting up. The cube is created in
Analysis Services. Recently one of the dimensions was rebuilt after one of
the member names changed. Since then we are intermitently getting a #Value
being returned. I checked a few things including the ...

I have a name and address of the person in one cell of  the ms excel sheet
and  I like to separate name and address in two cells by using any command.
like shown
I have ;