k, this is wht i have
sheet1 (short list of about 400 parts with no descripiton)
columns - part #     description
sheet2(complete list of about 2000 parts with description)

Hi again, people.
there is a message posted here about this.  The question
is there, and the 'thank you' is there, but nothing else.  
How do I get EXCEL to (automatically) change the color of

Can anyone help with this problem
I have a spreadsheet with 4 columns.  These columns are Cost, Yes/No, Area and Cost Code
I want to work out costs to each combination of Yes/No, Area and Cost Cod
e.g

Hi. I am doing an attendance sheet for my school. I have
14 different rooms (with a class sheet for each "room
1", "room 2") and a class roster on each sheet. I also
have a row that has the number for the month that the

I am pasting dates from Primavera Project Planner into an
Excel spreadsheet. When the dates have an A at the end of
the string it means it is an actual date rather than a
proposed date. I want to edit all fields with an "A" at

Ok, here's the scenario.  I hope I word this correctly,
forgive me if I don't.
I have a list (one column) of random numbers that could
change, ranging from 87.3 (cell B17) and 223 (cell B1).  

=INDEX('sheet1'!E2:E51,COUNTA('sheet1'!E2:E51))
i've got the above in a cell. which basically looks up the
last number in the E Coloum on sheet1. However due to a
calculation being put in all E cells...

=SUM(N71-(T71/1.4))*BJ71
If BJ71 does not have a value the error #VALUE appears.
I have tried to incorporate error checking into the formula without much
success. Anyone know what is needed?

I'm wanting to compute the number of days that have
already PASSED in a month vs. the nuber of days LEFT in a
month.  Just to make it trickier, I don't want to count
Saturday's or Sunday's.  So, here's what I'm looking

I?ve got a worksheet that has over 1000 rows that I need to run the
following formula on.
=INDEX(LINEST(B13:L13,LN(B3:L3)),1)
Trouble is that not all rows have values in all 11 cells (first section

I am very new at Excel (how can you tell!!) - how do I get the horizontal and vertical
lines that are on the screen to print onto the paper.  Thanks in advance for any help you can give me.

I have the following formula in cell f2:
=IF(A2<>"",B2-C2,"")
i want the result of B2-C2 to be put into cell E2 whilst
keeping the formula in F2.. How do i do that?

I have done a spreadsheet on medical terms and wish to
use the VLOOKUP function to return the medical term when
a Lay term is entered. When I do so, I get a return of
the wrong cell (one cell up). When using numbers in place

I need to count how many people are in my list, my list starts at row 2 and
ends at row 19 the cells are populated by other formulas:-
=IF('Thu 01st'!A3=0,"",('Thu 01st'!A3))
So if there is no value to be picked up the cell displays "" or nothing., I

I am doing a Lunch Detention spreadsheet for my
school and I have included 18 different classes on 18
different sheets, with all of the students from the
different classes  on their respective class rosters. I