Hi I am Useing conditional formatting to highlight items that are in a list
on the worksheet with function
=countif($d$1:$d$6,A2)
Where my list is from A2:c100 but when i use this function it highlight only

I have two dates, in two columns. One is a start date, and one is a
completion date. What I would like to do is list all of the week numbers that
are included in the range between these two. So for example, if my start date
is 1 January 2005 and my completion date is 21 January ...

 I am having problems using a count formula.  I have a list of numbers
and I want to count how many numbers are greater than 200.  I'm not
sure which count formula to use and how to use it.  Please help!
Thanks!

I have a worksheet, containing 380 rows, named ( Effective 1-1-05) that
contains columns named
stock#    mfg#description     each       lot1      lot2
A2                B2                     C2          E2        G2

I’d like to be able to do an offset from a reference in another cell… Help…..
Here’s what I really mean.
A1 contains ‘January’
B1 ‘February’

Hi I am Useing conditional formatting to highlight items that are in a list
on the worksheet with function
=countif($d$1:$d$6,A2)
Where my list is from A2:c100 but when i use this function it highlight only

This sounds so easy, why am I having trouble. I want to set some cells
so I can see them but so that they do not print out on the final
document.
Thanx.

thanks for the help, I need to clean up some data in excel,
I need to strip the letter and format the numbers.
i.e. (B=Billion M=Million)
9.965B    = 9.965.000

In VBA I'm setting a variable as follows:
NumRows = Sheets("Summary").UsedRange.Rows.Count
and NumRows is subsequently used to make sure a chart has the correc
last row after an update that changes the number of used rows in m

Interest rate: 6.9%
Amount: 2500
Period: 24 months
The company says monthly payments wil be 111.63. But none of the excel

Excel 2003
Question:
How to write an if then formular to take the "0" out of the linked pages in
the spreadsheet?

I am using Excell 2003
I'm trying to set up an "IF" formula in one cell to to assign office
location to postcode located in another cell. for example
=IF(A1="BD*","Bradford","Leeds"

Is it possible to sum up the minimums of each row in one line commmand?
E.g.
 A  B
1 5  6

I have an IF formula and need to change the font colour of the FALSE value to
red - how do I do it?????? Help!!!!

really appreciate if someone could help me
sheet1 has a list of mobile telephone numbers. ( with some details
regarding each number, name, status etc, but none of the details are
filled in)