Yep, I'm hopeless at Excel but I'm not an accountant and only have to use it
once or twice a year for student marks
Anyway, I have two columns which I need to add and then divide the total by
2 to get the average

I want to build a summary tracking sheet that looks at week by week
data in other spreadsheets.
The data i.e. grand total may not be in the same place in the other
spreadsheets week-to-week i.e. but I always want to pull together the

How can I make a list of the dates of all Fridays in the period beginning in
2002 thru 2007, or year by year?
Thanks.
-Dennis

I have a spreadsheet where I've used a form to enter a customer's
detail and the price of the ticket.  I've got a macro that adds that
information to a worksheet.
I've then got a countif formula with absolute cell references to count

How can I  apply a forula to numerous rows at the same time?

Apologies if you people already know this - but I was asked a question
by someone I cannot answer.
The person was setting a conditional format too show values >= 0.03,
and he have the following calculation in to arrive at this value - but

Today I received following re how to change button background color.  But I
do not know how to get to design mode.
I am using excell 2000.
hi

The Data sheet contains a column with numeric values. The lookup table
deliberately does not contain all of the values found in the Data
sheet. When the formula
=VLOOKUP(I6,Fire,2,FALSE)

I have what seems a pretty straightforward question -
How, in *one* formula, can I check a range for a value?
i.e. Check whether any cell in the range A1:A9000 contains a zero,and
return 'Yes'.

Hi -
I am sure this is easy, but I am not savvy with macros and programming in
excel to figure this one out.  
What I need to do is to take the last date entered in a column of one

=IF(ISNA(VLOOKUP($A1,Sheet1!A:F,2,0)),IF(ISNA(VLOOKUP($A1,Sheet2!A:F,
2,0)),"not present",VLOOKUP($A1,Sheet2!A:F,2,0)),VLOOKUP($A1,Sheet1!
A:F,2,0))
the avove formula return the data on sheet two but not on sheet one.

Have a xls file with 400 users in it with the following fields:
Employee Number, First Name, Last Name.
I want to add another field which shows me LastName and first intial of the
user.

How can i create command button that is red with white letters?
I know how to create button with diff letters in color.
thanks for help
bob leonard

I have a computer with excel '07 and a computer with excel '03.
When I view the .xls document in '07, then all the formulas work fine.
When I view the .xls document in '03 then several of the formulas display
the #NAME? error. halp plz.

I'm an excel VBA total novice.  I dabble in access vba, but am unsure where
to start in excel.
What I need is some code I can tie to a macro (& keyboard shortcut) which
will find all values under 1000 in the selected range and change them to