I have 3 columns: Date|Time|Activity.
26-Oct-06    13:20    Sanity Testing on File Maintenance.
    14:00    Stopped.
    14:15    Resume Sanity Testing.

I would like to rank a group based on two Criteria, and i can't figure it
out.  I've got a list of 10 teams and I want to rank them based first on
winning % then by total points earned.  Here is an exaple of the dataset:
    A          B

I have a worksheet (#1) that references another worksheet (#2) line by line
and copies select information into the sheet.  When I delete lines in #1 the
#2 comes back with #REF! for the lines that I deleted in #1.  Data in #2 is
imported into another application and the format is ...

I ed to write a formula on sheet 2 that includes data from cells on sheet 1
of my Excel spreadsheet. Help

How can I format a date into the fomat yyyyddd where ddd is the day of the
calender year (i.e. out of 365 or 366 if a leap year. Assume my date is in
cell A2.
Bruce

I am sure this already answered, but I can not find it, so forgive me in
advance.
I created a Excel Spreadsheet to make some forecasts... anyways I have a
formula that will always be pulling from the same two cells and one that

Ok, followed this in an Excel2003 workbook, and got ALMOST there. I was able
to get the reverse returned, but then adding the *1 returned a #VALUE! error.
Clicking the error tab did not give me the option to Convert To Number,
either.

Hi
I'm using condition formatting with the following conditions:
**Change cell $K1 to Blue if the content equal 'Extension' (working fine).  
**Change the entire row to No Fill when cell $A1 equals "C"

How do you add the scroll bar to the combo box?

Is it possible to format a row based on a text value compared from a cell in
that row to a cell in the row above it?
I review a report daily that is about 200 pages long, of which 80% of it is
duplicate information.

I would like to merge data from two worksheets into one worksheet based on a
key data value.  Here is the data:
Worksheet 1
ColA    ColB

I want to sum amounts from one column if 2 other columns meet the criteria I
defined.
Here is what I have: =IF(AND(A:A="x",B:B=""),SUM(C:C))
Even though I have a lot of rows that match both criteria (have an "x" in

I have an Excel 2003 file with >8 columns that one could filter on.
The AutoFilter function is set to ON.  I have found that the users do
not always remember to click on (All) in the filter drop down menu
before moving to the next column and filtering...they end up with

Looking for formula help. Here's the situation:
Excel doc using one tab per month and then a quarterly (ex. 01.07, 02.07,
03.07, Q1)
Cell E5 references a dollar amount in each monthly tab.

I'm starting on a course in statistics and we have to do a lot of index
numbers. Now Excel is good at this as long as the indexes are simple.
But I can't figure out how to do Laspeyres, Paasche and Fisher indexes using
Excel. Any Ideas?