i want to automatically indicate the person with the higest score ...
Name    Name    Name    Name    Name
 851.18     545.74     443.38     2,663.11     3,961.84

In Excel 2003, I have a user who would like to prevent duplicate product
numbers from being entered on any of multiple sheets in a file.  Since
conditional formatting, countif, and vlookup don't work across a 3-D range,
the brute force method is doing multiple lookups, countifs, ...

We have a spreadsheet with various details relating to a person whose name in
Column B of the sheet.
We want to create a warning message when anyone tries to delete the name.
Does this require a Macro, or is there any other way to create such a

What I'm trying to create is a sort of calendar that has the 7 days of the
week as the column headers. I want the headers to display the day of the week
and the date depending on what week it is. So if it's the week of September
9th, I want A1 to show 9/9/2007 - Sunday, A2 would ...

I know this is an easy one for you wizzes, but it escapes me at the moment
and I never seem to have the right terminology to look up what I am trying to
do.
I have two columns of data (A, B) and a third that is the result of a

My data looks like this:
A    B    C    D
0.00%    0.00%    100.00%    0.00%
5.92%    7.06%    13.98%    32.51%

I am trying to save some time and possibility of error, by linking cells in
an inhouse workbook, to cells in a number of workbooks received by email.  
The workbooks receivd by email have the same name each day.  I want to
eliminate the need to save these files, as this is ...

I used the following formula to calculate the difference between two dates:
=DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
"&DATEDIF(A2,B2,"md") & " days"
01/01/2006    28/02/2006    0 years, 1 months, 27 days

I've boiled down a problem Function to the following statement:
=IF(I54=OR(2,3,4),"Low","")
I54 = 2
Function returns ""

Hi, I want to calculate the % of negative values in a column, using a dynamic
range. i.e No. of negative values, divided by total number of values, X100,
to give a %. The following formula works, but is returning the wrong value:
=SUM(COUNTIF(INDIRECT("$C$13:C"&A2) ...

I have to make a spread sheet using Microsoft Excel. I have to be able to
tell drivers when there DOD cards are due for renewal and their driver
license also. What is the best way.  I'm talking about 3500 drivers. Your
help would be greatly appreciated. My email is: ...

I am looking for help with the following formula
=IF(AND(H45<$B$1,A45<>207003),($B$1-H45)/(H45-G45)*I45,($B$1-H45-($B$1-H45)/7)*2)
I want to have something else onto the formula which says that if the entry
is less than 0 then enter ""

I have made a DateStamp using this formula:
=TEXT(TODAY(),"d/mm/yyyy")
But when i go back to the work sheet the next day it a automatically
cahanges the date. Is there any way to stop the automatic update so the date

I have 2 sheets and on the first one I have used a function to calculate the
average of each successive group of 10 values. Then I want to take all of
these values without the gaps that are present between calculated averages
and have them placed in the second sheet. My reference ...

When using the following formula:
=VLOOKUP($C$2,'Mandatory Training'!$A$5:$Z$100,A6,0)
The cell reports a date even though their is no date entered into the cell
it is looking at on the other spreadsheet.  How can I get it to only rpoert