Using Excel 2000 and without having to get into Macros, is there a way to set
a validation such that only an uppercase character can be enterted into the
cell?  For example, the cell would allow an uppercase "X" but nothing else?
Thank you for all help / suggestions,

hi, i am interested doing something like this:
=SUMPRODUCT(--(B1:B12="criteria 1");--(M1:M12=B29);--(I1:I12))
where B29 represent a value that i introduce in cell b29
thanks in advance

I was wondering if you could help me out in here. For example, I have this
scenario of a database of 5000 employees who do many business travels. Some
of these people have their tickets booked by Helpers and some do their own
bookings.  Notes that some names on the database ...

I have a column of dates such as 8/5/06, I would like to create a formula
that counts the number of dates for a particular month.  For example, if the
column reads as such:
9/13/06

I am trying to write a formula using the IF funciton.  The formula itself is
fine.  My problem is, though, I need more than just seven conditions.  I
actually need 12
The formula currently reads like this:

I have a document that contains rows in a group.  When I have my sheet
protected, I am unable to open the group if it is minimized and unable to
close the group if it is maximized.  Is it possible to open and minimize a
grouping when a sheet is protected.

When looking at a range of cells, I need both the contents of the maximum
value in the range and the actual cell address of that cell.  For example, I
have a series of readings from A1 to Y31 to represent every hour and day of a
month.  If the highest reading is in the 11th hour ...

I'd really like Excel to have an All(range, criteria) function, as used in a
number of programming languages. For instance:
    A    B    C    D
1   y     y    y     n  

I need some help with writing a 'search & display' formula:
Scenario:
cell A9 has a value of $4600
-> set cell T2 to '=A9'

I have created a forumla in excel which selects the the highest value in a
range based on certain criteria contained in a neighbouring cell, it is shown
below:-
=MAX(IF(YOT!$B$3:$B$150="England",(YOT!C$3:C$149)))

I have more than 3 conditions that I would like to apply, is it possible to
use = with  OR in conditional formatting?

I have a spreadsheet where I have a list of part numbers (in rows) and then
a series of percentages across the top in columns e.g.
Parts  10%  20%
123    52.50  33.50

I'm trying to get an average of a series of averages. Some of the cells in
the series have a 0/div error, which is ok for the series. I can't get the
average of the averages formula to ignore the error cells. Here's what I'm
trying:

I have a sheet that has conditional formatting  that anything after a todays
date is red.  What I really need is for that date that it looks at to never
change.  
For Example:

1. Countif with multiple criteria.  I have tried sumproduct as follows...
=SUMPRODUCT(('Jan 06'!A:A="B")*('Jan 06'!G:G="TRUE"))
but this gives me a result as #NUM!
The cell is set to general.