I've designed a simple spreadsheet to track grades using Excel 2003.
Each specific assignment/quiz grade for a student is in a separate column.
The beginning row of each class contains the highest grades possible for
each assignment/test/etc.

I'm having trouble locating the max time vaue from a list.
I have a list formatted as (hh:mm), whenever I use the Max function id
doesn't signify the hightest value. I've also tried using the Large Function
with 1 as the signifyer but this doesn't work either. eg

I have a Music spreadsheet.
Column A - artist, B - Genre, C - Music style
1. I would like to somehow have multiple values in column C.
2. Additionally if I autofilter I'd like the autofilter to be able to filter

i'm trying to reprogram the NPV function as in Excel but i can't seem
to understand how excel gets the result it is giving
for instance in the help i see this example:
annual discount rate: 10%

I am trying to set up an IF calculation as below:
=IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50)))
The baove is fine but i now need a 2nd condition as below.
I want to add a second condition to it say like:

Ok so basically I'm looking for an easier way to have a school timetable show
up.
essentially, when we are given the list of offered courses we are given both
a timeslot code (1 through 60) and the days/times this code refers to, so i

I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?

When I click on the saved EXCEL document on my desktop - Excel opens with no
workbook - just grey screen (DONE in bottom left corner).  I am able to
access workbook via opening a file from this grey screen, however, I can not
find how to correct this error.  Help much appreciated ...

I have an array formula that is working perfectly:
{=SUM(IF(Quote_Code=A3,Quote_Amt,))}
I would like to make one change, but I don't seem to be able to get it
working.  When the locigal test is false I would like to dispaly nothing in

I'm relatively new to VBA.
My problem is I have created a combo box and I want the user to be
restricted to the drop down selection only.
Example. If the user has options of choosing from A, B, C and D...I

After I data sorted the spreadsheet the email and web site cell's take me to
the wrong addresses. Its like the link stayed with the cell instaed of the
address.

Hi I just wanted to know if there was a formula I could use so data in column
A could be replicated in column B except without certain values from column A
which contain certain bits of text.
For example, if column A text contained the word "dog" I would want it to

I've got a small table of financial data that I want to summarize on a
second worksheet in the same workbook.  A sample of the table is right
below.
I'd like to say if Column C = 1 and Column D = Editorial, then retrieve

I trying to right click on move or copy a sheet at the bottom of the page,
but the move or copy isn't highlighted anymore.  Insert, delete, rename or
move or copy is in light gray and won't let you click on it to choose it.  
Any help would be greatly appreciated.  

Not a programmer, try to write a macro to refresh a chart base on the
range I choose, say, in the previouse step, set  "A1:A1, K1:P1, A5:A5,
K5:P5, A10:A10, K10:P10" to string variable wkrange.
then: