I am making a list of names that are to be placed in a schedule and as those
names are used I want an "X" to appear in a list of days in the week to know
when scheduled

I've got a spreadsheet with data in the following manner
Date             NUM1  NUM2   NUM3
3/10/2006        1        2         5
3/11/2006        2        3         1

I have 2 workbooks and each of them has 2 columns ITEM and DESCRIPTION. I
want to compare the item numbers and if the item nubers match want copy the
decription from workbook 2 to workbook 1 beside the description in workbook 1.
Thanks.

I have several hundred cells with =ROUNDUP(formulas, 0).  I want to
erase the ROUNDUP( ,0), but don't know how to use find and replace on
this.  I can't do it in two steps, because then Excel doesn't like the
resulting formula after deleting either ROUNDUP( or ,0).  Is there a

I'm trying to format a cell to only allow a numerical value that is a
multiple of 6.  Is there a function or conditional formatting that can handle
this?

I am working with daily returns over a period of less than a year that I
would like to annualize.  Excel help mentions something about list 1 to 30 in
the STDEVP(list).  I am assuming I can use more than 30 values or?  Also what
would calc would I use to annualize the result of ...

I'm trying to do a chart using dates.  I would like to set it so that if A1,
or B1 is blank, then C1 is also blank. If BOTH A1 and B1 contain information,
then C1 = A1 + 1.
I have tried this, and it doesn't work.

I've created sevreal workbooks that are linked to one large workbook.  Is
there any way to protect the linked data if the original large workbook is
deleted?

I started a thread with a casual comment on COUNTIF and blank and zero.  Then I did more tests which led Sandy to do hers and discover that according to COUNTIF
"" = Blank but Blank < > ""
Roger confirmed the finding by doing a detailed and interesting test using various versions ...

cells at are:
2.5  = f3 / 0.89 = H3.. #value! should be: 0.36
=IF((F3/H3)>0.99,TEXT(F3/H3,"$0.00"),TEXT(F3/H3,"0.00¢"))
On another line with same formula:  this works

I have a column of texts. All of texts have the word "function" at end of
them.
I want to delete this word from end of all texts.
How can I do it.

I have a sentence in cells of column A.
Sentence starts with a capital word and the next word starts with capital
but the rest is small.
I want to separate the first total capital word from the rest.

My data in my pivot table holds negative numbers, therefore my Grand Total
minuses these negatives, ie 6, -2, 4 grand total = 8.
I need the Grand Total to only add anything over 0, so the above equation
would equal 10.

I want my header to say "R&D" but when I type that, it thinks I want R
10/25/2006 (date autofill for &D).  how can I prevent this and get an
absolute text value for R&D??  thanks.

I have 2 different sheets, 1 for ship A and 1 for ship B.
Both these ships have part numbers and prices associated with them.  Lets
say Column A has the part numbers and Column B has the prices associated with
these part numbers.  My task is to compare the 2 sheets, find part ...