I have to use a formula for due date in which there are constraints such as,
If item is of type I or type II, then,
{If an item arrives between 11:30 AM - 4:30 PM, it moves exactly after 4 hrs
from arrival.

Hello to all! My first post! Help me if you can.
I have the list of all months in cells B1:M1 (ie January, February
etc). In the cell under each month (i mean in B2 for January, C2 for
February etc) i enter a number, always number. What is the formula that

Is it possible to use the auto filter functionality with a passwor
protected worksheet?  I want the user to be able to filter their data
but I want to protect and hide my formulas.  Thanks for any help.
Joh

Dear Wizards,
I have a year's worth of data.  Each day is on a row.  The number of
patients in the ICU is in col C.  The number of those patients that were
'status 7' are in col D.  I want to create another grid that tells me:  How

Hey I was working on something and I cant figure out how to put normal
text into a formula, for example:
COUNTIF(A1:A5, "SOLD")/COUNTIF(B1:B5, "ITEM")
I want it to come out like this: 3/5 but of course it divides the two

I need a timesheet that will allow daily time input that rolls over to the
next day, i.e., 22:00 in the evening to 06:00 the next morning (new day)...
Thanks...
John

I am trying to add a functional scroll bar in a cell of my Excel worksheet.
Is this possible?

Having a little problem getting this code to work I tired many things
including IF commands & VLOOKUP and I either get a N/A or False response from
the codes I have tried. It consists of three columns listed below.
A / B / C

My worksheet (w1) has values in cells A1:D20. All cells have a formula or
link to another worksheet. Some of the cells are blank (but still have a
formula in the cell). All of the cells change periodically as I change the
values in other worksheets.  In worksheet 2 (w2) A1:a20, I ...

i tried diffeernt methods. i can either convert days to hrs or hrs to days.
but am not able to do both. so if anybody can do it. plz let me know.
thanks
chris

I need to create a formula to substitute a letter result for a range of
numerals. That is I want to represent a letter grade for a range of
percentage results. Any tips?

When lookup_value corresponds several value in table array, it only
catchs the first value/cell with vlookup function, how to catch the
second and more value?

=LOOKUP(I6,Index!$C$8:$C$60,Index!$D$8:$D$60)
I’m using this code on my excel sheet and when Column I6 is blank it shows
N/A in column M6 how can this be removed not to show the N/A
Thanks ahead!

I have added conditional formatting to several cells. The condition i
if A2=A1 then make text in A2 white (not visable).  The problem I a
having is I have 10,000 cells that check to see if they are the sam
number as the one above it and the user does block copy and paste o

Forgotten how to split into separate columns. Have FirstName and Surname
together in one column (unfortunately some have a missle initial).
Want surname in separate column.
Tried Text to columns, but inital letter messes up the split.