Does any one knows how to stop formatting cells automatically?  I
didn't tell Excel to format cells into any category types or formulae
but it changes the numbers of the OTHER cells automatically whenever I
type in a number.

Your help will be appreciated. PROBLEM:  The formula below returns an answer
of 100% (WHICH ISN'T RIGHT).  The correct result should be 11%.
=IF(COUNTIF(F18:M18,"<>0"),LOOKUP(2,1/(F18:M18<>0)*ISNUMBER(F18:M18)),AVERAGE(F18:M18)-AVERAGE(F22:M22))
WHAT I AM TRYING TO ACCOMPLISH ...

I have a large XLS which has columns containing multiple text initial
of people separated by commas and spaces within each column such a
below. I need to be able to count the number of occurrences of eac
initial within a column into separate cells at the base of that column

I have Budget SpreadSheet thet is set by month(U3), then Budget(U4),
Actual(V5) columns. This is repeated 12 times across the sheet. I then
have "Buget Average" and an "Actual Average" cell. The budget average
is easy because all cells have values for all 12 months. How do I

how do i setup conditional formatting to reflect the following:
- when cell is blank, change into red background
i know how to setup "change into red background"
but how do u specify when the cell is blank?

I want to create a formula where a cell will automatically be shaded a
certain color if a number is >= a certain number

How do I combine A1, A2 and A3 to look like this: 3:15:56?  Does it
matter that the data is in Sheet1 and the final product is in Sheet2?
Any help is welcomed.
Sheet 1

Let's say I have thousands of employees, but I need to determine who
worked for me during a particular date range, and all I have to go on
is their start date in one column and their end date in another
column.

I am trying to create a formula to look at a certain cells, and if
those cells contain the value I am looking for I want to return that
value, look at another cell and return that value as well separated by
a space and so on up to a possibe 5 different return values.  I think

THE CUMIPMT() IS NOT PRESENT?

Is it possible to use Vlookup and grab the hyperlink from the cell? If so,
how? If not, is there another method?
Similarly, can you grab a comment or the cell color while using Vlookup?
Thanks

In column A, I get a list of name, which name can be duplicated, such as
John, Mary, John, Peter, Amy, Mary, Amy, Peter
I would like to create a menu for listed names, which name cannot be
duplicated, such as

Here's what I have:
An array of bird counts.  4 (yearly) sheets with bird counts.  The
first column is the list of species, the second column is the sum of
the remaining columns, the successive columns are the counts for each

I have a vertically, names of peoples (20) and horizontally (15)
different objects. In each cell the total of objects for each person.
I would like to go to the different cells, run a macro maybe, enter a
value that will be added to the existing total in that same cell.

I have a list of clients and the time they were seen. I need to count how
many clients where seen between set time eg how many were seen between
12:00:00am adn 04:00:00am
Please help