I am trying to perfrom a lookup function. There are 3
columns and unfortunately the data is sorted in ascending
order for the 3rd column. There is another lookup formula
at work there. The lookup vector for my second formula is

I would like to use Sum to toal a range but exclude any data in hidden rows.  That way I could filter another column and run totals for the rows that meet the filter criteria.

I have to do some SD calculations, however Excel will
only allow for 30 groups to be evaluated, I have 120
groups to evaluate, any ideas?
Thanks

I am receiving an Microsoft Visual Basic error message
when I open up Excel 2000.  
It says:  Class not registered
Looking for object with CLSID:{AC9F2F90-E877-11CE-9F68-

I have looked around in this site and found partial answers but not t
the full problem.
I have 2 list of name and score.
List 1 is the master list with a old score

A workbook was created using EXCEL 97 using defined
names.  When the spreadsheet is opened using EXCEL XP, the
defined names are gone.  Is there a workaround for this?
Thanks

i am trying to combine 2 SUMIF fuctions to perform the following.
i have a list of employees,  each has the following information.
WEEK NUMBER-- EMPLOYEE---JOB REF---Hrs worked
(each employee may work for a number of diffenent jobs over the sam

I am very familiar with the PMT Function and use it all the time at
work.
However, I now need to do the opposite...I know the monthly payment and
want to solve for the value of the loan.

I am trying to use vlookup to search a column of number and numbe
letter combinations and return the number in corresponding column (ie
2 returns 33)
1             45

I'm using VLOOKUP to compare two lists of names to see if the same name appears in both lists. Both lists are single columns. What I'd like to do is trade in those ugly #N/A designations for either an empty cell or the text string No Match
So, my question is as follows
How can I ...

I am looking for a keyboard shortcut (like ctrl-c for cut)
that will paste special only values, not formats or formulas.
Does one exist?
Thanks

Trouble with seemingly simple formula
Original written formula (C4 and E4 are separate formula results)
In this example C4=1.02 E4=.61
C4>.66 and E4<.66 = Disc (Correct answer)

I have a little problem with rank function.The thing is as
a teascher i have to give ranks for each student. But if
70 is the highest and is got by two students, second place
does not exist. So I want to give the second lower student

I am having a problem when concatenating 5 columns of 2
digit numbers which do have leading zeroes for 1 through 9.
Even though the column cells can be formated to view the
leading zeroes the formula drops them. I want it to keep

I'm trying to use a part number from one list to find the
same part number in another list in order to get the
updated value of on-hand inventory.  I know this can be
done with an excel vlookup but the only problem is that