Hi there. Any help much appreciated
My formula HLOOKUP(P21,Levels!$C$7:$O$1800,MATCH(O21,Levels!$A$7:$A$1800))
has worked fine for the last 10 years. All values in cells C7:O1800 have been

I have a spreadsheet but a few of the cells have been passwor
protected.  The person who created it has long gone and took th
password with him, does anyone know how I can unlock those cells. I a
a relative novice. Thank

This would be very nice for those involved in the financia lindustry who use
a DDE to monitor stock and futures pricing.  
Under certain conditions the cell would flash
----------------

I have a cell which contain a hyperlink.
Now I want a formular to pick the hyperlink in this cell.(result is a text)
Example:
cell A1:    "Music"  (it was formated as blue and underline by Excel) and

I would like to use SUMIF to add up numbers occurring in a row that spans 12
columns (months of the year) if the condition is met in the same row in
another column.
This is how I tried it: =SUMIF(B2:B13, "=STA", H2:S13)

I'm thinking that everytime we offer a pay plan to a customer, we lose
money by not collecting payment (premium, since I am in the insurance
industry) in full at the time of sale based on either a present value
or npv calculation. I would like to be able to calculate that loss for

How do I format a cell so it automatically shows a 0 as the first digit when
I input a numeric value insted of using the ' prefix?  The cell is used for
order numbers which can begin with a 0

I need to create a Employee specific worksheet.  The information I need is
based off of a daily production worsheet.  I can not figure out a formula to
use.  I need to have a total if the employees name is entered.  This would
have to be the result across 30 other worksheets.  I ...

How do I change colour from a white sheet to black?

I have a spreadsheet with headers for a mailing.  When I do the mail merge
the first digit in the zip code is dropping off.  I have the cells formated
for zip code and it is still doing the same thing.  Working with Office 2003.

I am using excel to make a line graph with two lines. The two lines cross and
I want to know the exact point where the lines cross, however can't get my
computer to trace either line to figure out the exact point.

all i am trying to do is add j82 and k82 excel is returning a value of 0.
First i thought the formula was incorrect =j82+(k82/100) but that was not it.
Next i check the format of what's being added, they were all set to number,
no problem there. Next I Evaluate Formula this is ...

I'm trying to convert an existing spreadsheet with 600 rows of data to upper
case text

Could anyone please give me any suggestion on how to code following condition
in excel?
In colume A, it displays the date for activities.
In colume B, it displays a list of activities for everyday, such as input

problem: Have around 300 student records want to produce a chart for
each one, the chart contains 4 pieces of data for each student and is
unique to each student, I want to produce a seperate excel template for
each student e.g.  i will end up with 300 seperate excel files prefably