I have a sheet to track the breaks of the team. in the last column i have
total break that is (In time - Out time).
now when a person enters Out time the total beak shows ###### because In
Time is still not there. I tried ISERROR but it didnt work.  any ideas?

Hi friends,
I am in the middle of Creating Ids for the customers. I have somewhat
succeeded in it. I have the data as below:
Col1         Col2        Col3     Col4    Col5

How can I get Data Validations working across different sheets in the
workbook i.e I want the validation in sheet 1 but use the data in sheet 2.

i am trying to make a formula that once an invoice gets so old that i am
alerted by the changing of color in the cell.  the problem is, is that it has
been so long since doing formulas that i cant remember one to accomplish
this.  any help would be much appreciated.

suppose i am making a spreadsheet showing me a people's details. and a person
has more than one hobbies and i want to diplay them in the single cell
corresponding to hobbies column header, how do i go about it?

I have an Excel Worksheet in which I want to set up a drop-down list with a
list of data to choose from.
Example:
1 to 3 hours

i need to remove figures from a cell in a already formated spreadsheet but i
don't want to remove the formulas.  can someone refresh me on how to do this?

Previous posted on microsoft.public.excel ......
Hi Folks - I need to provide counts and percentages of survey data. If
Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many
1's, 2's, etc., plus calculate the percentage of the counts to the total

I have used all format options and cannot put in numbers without them
defaulting to 2 decimal places. I put in 22 and when I move to another cell
it defaults to .22. If I format the cells to 0 decimal places, it zeros out
the numbers. I have tried verything including ...

I am importing date into excel via an external data query with Access. In
excel I have the following formula:
=IF(ISERROR((EOMONTH(B2,-1))+1),0,(EOMONTH(B2,-1)+1))
where B2 contains a date imported from Access (in date format, not text).

I have a sumproduct formula set up and it is working. the problem is that the
data it is pulling increases through out the month. When i try to set it up
to look at A:A it does not work. It gives me a #NUM!. If I put A1:A163 it
will work. The problem is today it may go down to ...

I am having a time with this one.  I am close, but just can't get there.  I
have 5 columns A, B, C, D, and E.  If A1 has a value, E1 would equal
(A1-C1)/C1.  If B1 has a value, E1 would equal (B1-D1)/D1.  If column A has a
value, C will not and vice-versa.  How would I do a ...

Hi, please help I need to add 2 cells together but in some cases there is an
error (#N/A) value in one of cells.  How can I ignore the #N/A but still
return the value of the other cell?  Everything I've tried returns the value
#N/A.  Please help!!

I have a workbook with two sheets.
Sheet 2 has data like:
pt          R5        R6        R7        R8         R9
010      76.0      58.1     51.3      45.8      37.5

I am trying to add numbers that have alpha characters at the end.  I have
tried nesting the SUM and IF functions using FREQUENCY for unique values but,
have been unsuccessful.  Any suggestions please.