Hi our schedule sheets now need to be encoded with a specific letter or
symbol for each possible shift.  This include upper and lower case letters.
and most of the symbols on the key board.  Will how do I get Countif it
differenciate an "A" form a "a".  and will this work for ...

I have a pivot table wth a field in the column area containing two values,
yes and no.  My data is then filterd to these two columns.  I have created a
calculated item adding the yes and no for a total people. I created another
calculated field to compute the percentage of 'yes' ...

My first worksheet that contains a list of error codes. Every week I
receive a new count of errors for each code so I add a worksheet with
the new counts and use VLOOKUP to add the new counts on the first
worksheet.

I have the following formula that calculates a MTD total based on the
date in AL3.  Cells B5:AF5 contain the date range 07/01/2006 through
07/31/2006, and cells B6:AF6 contain the numbers to be summed.
=SUMPRODUCT(--($B$5:$AF$5<=$AL$3),$B6:$AF6)

i want to show some cells in another colour ( eg. numbers more than 10% in
red).how can i do this?

I am trying to use NETWORKDAYS to eliminate Weekends in my calcutions as below
A1 Cell contains 6/30/06
B1 Cell contains 7/5/06
using NETWORKDAYS(A1,B1), it should produce (48), but shows (96),  Noting

I am making an excel file that should convert the distance jumped by
person to a specific rank. For example if the distance was greater o
equal to 34, he would get a 10. and 34> distance >= 32, he would get
9 and so on...

I want to Convert my data into BARCODE FONT 128 B type..the data is like
example RBOR00332233, that requires a definite checksum character for each
unique data. Is there any function (inbuild or user-defined) pleaze forward..
I want to calculate "CHECKSUM" of MOD 104 which is ...

Hi, I currently produce my nursing rota using excel, whereby the weeks
shifts for all the staff are produced on a couple of A4 printouts. We
then take this information and transcribe into a diary those staff
working an Early, Late or night on the Monday of that week, then the

I'm trying to paste some HTML code from Front Page into the cells in
column A.
I copy the code in Front Page into Word. I copy this and highlight A1 in
excel. Then I open Paste Special and use copy HTML. I don't want Excel

When copying from one workbook to anather, the day date is one day later and
the year is four years later. Is there some way to fix this?

I have 898 rows of information spread across 13 columns.  Column "G" has
dates (898 *different* dates...).  What I want to do is set a conditional
formula to change the font, of the whole row, only if the date is older than
"today".  I must be able to select all of the cells and ...

Here is my current forumula:
=IF(F6<=4,"0",IF(F6<=8,"1",IF(F6<=12,"2",IF(F6<=16,"3",IF(F6<=20,"4",IF(F6<=24,"5",IF(F6<=28,"6",
IF(F6<=32,"7",IF(F6<=36,"8",IF(F6<=40,"9",IF(F6<=44,"10",IF(F6<=48,"11",IF(F6>=52,"12")))))))))))))
I am only allowed to use a certain number of commands in ...

I have a worksheet of rows of customers and columns of products.  There
are about 250 customers and about 100 products.  Therefore, there are
25,000 cells of data.  Each cell contains the dollar amount of that
product sold to that customer.  I would like to create a 3-column list

I am working on a business budget in excel, and want to link to a
confidential payroll page. Is there a way to link to a payroll projection
page in the same excel spreadsheet, and password protect a single page so
that the viewer is not able to view the specific contents of the ...