I want to stop a cell in excel being left blank once user has clicked on the
cell.
I have a column that has to have a Y or N response.  There is data
validation on the cell sop only Y or N can be entered.  Nowever once the user

I am just wondering if you are able to have two functions in one cell.....
However, this is probably more complicated, as I would like to round up to
the nearest 5, rather to the nearest 10?!!!
Scenario, in my cell at the moment, I have the sum function, adding a few

I have a feeling this was asked many times before. What I want is a
simple formula to calculate hours worked. From the time cards an "IN"
and "OUT" time is read. All I want is to put in column A "time in" and
in column B "time out" and get the "total hours worked" in column C.

Is there a function/formula I can put into a series of cells which can look
at a list (with repeat entries) and simply return the unique one.
E.g.
Tomato

I am creating a formula, whereby each person has a different percentage.
At the beginning of the chart, I will insert the correct percentage and my
formula will point to that percentage, in order that I may use the same
formula across the board.

I need to have 2 mores options (ie HVAC_4 & HVAC_5)I am aware that I am
limited to 256 characters and making the range names smaller may help,
however is there another way of doing this that may eliminate the limitation.
I may also be reached during working hours at my office ...

Column A has the date and time displayed: Thu, 06/14/07, 11:15
Column B needs to calculate: "If (A=Mon to Fri from 7:00 to 20:00, Sat from
7:00 to 15:00, Sun from 7:00 to 16:00 Then Display in Column B "On Time")
If False then Display in Column B "Closure Time")

I have a spread sheet with three years of monthly data.  I need to calculate
for a rolling twelve month total each month.
(i.e.)
sum data in columns for (Jan2006 - Dec2006),

I have a fiscal year with a year end on Oct 31st.  I have a tariff that is
expressed in $/month.  Say its $6000/month. I want to use a start date input
with the tariff to adjuste the annual fiscal amount.  Say I have a term of 2
years.  My Starte Date for the tariff is 1-Dec-2007 ...

I have a spreadsheet that a column of cells are color coded. I would like to
count the number of cells that are of the same color. How can I do that?

I am trying to write a macro that will delete rows from a spreadsheet based
on a condition.  I pull information from another program into excel for
budget purposes and it throws the company names in the header in column form,
so based on how many companies I pull in the number of ...

I have a worksheet that is not protected, however it will not allow
paste after copy, but i can paste into a new sheet.  Any ideals as to
why this is happining and how i can fix it?

How can I change the comparison formula for each cell the condition is
applied to. Example: B2<(E2)+(F2), I need to copy the condition to other
cells but to change relative to the cell location, B3<(E3)+(F3) and so on
down the column? I have tried this with and without the $ ...

I'm pretty comfortable with VLOOKUPS but having a difficult time
understanding MATCH and INDEX.  I'm trying to fill in column D on Database
Table with column C from SAP Table where Columns A and B from each table
matches.

I have a spread sheet that has 1,500 rows and 27 colums. Starting at 9P are
client names and I am trying to indentify specific clients by name only, no
formulas or sums. How can I identify the 20 clients by name?