Some of my colleagues are getting "circular reference" errors upon opening
some Excel (2003) workbooks. I can open those same workbooks (also using
Excel 2003) and I have no problem.
The cell being identified as having a c.r. has the following formula:

i asked a question like this last week but i did not have all the info on how
my ifs statements were going to work but now i do so hopefully y'all can help
me out again.  I want to keep the info in one cell so i understand this will
be a pretty long one.

I'm counting excel records (rows) using the following conditions:
=SUMPRODUCT((Ship05!$A$2:$A$428<>"")*(Ship05!$B$2:$B$428>DATEVALUE("03/31/05"))*(Ship05!$B$2:$B$428<=DATEVALUE("06/30/05"))*(Ship05!$M$2:$M$428="Freight
Damage"))
Instead of "Freight Damage" in column M, I want use a ...

I am stuck with the logic of the "OR" in this sub
whilst
If Cells(RowNdx, "A") <> "CAR" Then
works in the below sub

I am looking for a way to utilize the max or maxa functions that returns a
value depending on if it's less than a value. Assume:
B1 value is 8
A1:A5 values are:

Here's the deal:
Think of this as a royalties issue. Depending on the sales for a specific
month, the percentage of royalties due will change. Say January sales were
$1,850,00 (A1). Then the royalties would be 3%:

I'd like to set up a formula (function?) that says,
If this cell is blank, then use this formula.
If the same cell has data, then use this forumula.
But I just can't figure out how to do it. Any help would be great.

I am not sure whether this is possible or not. I have created a front
end screen so that I can open a series of spreadsheets I need
throughout the day. However, there are a couple of problems I need help
with.

In Excel 2002, I have a functional conditional format for one cell.  When I
attempt to follow what is stated on
http://office.microsoft.com/en-us/assistance/HP011739141033.aspx and “select
the entire range, click Conditional Formatting on the Format menu, and then

I have 2 workbooks: stores.xls and sales.xls. Both sheets have a column that
contain a store number. stores.xls also has gross sales listed in column F.
The formula will reside in sales.xls (column G for each row). What I need to
do is compare [sales.xls]A2 to column C in stores ...

I know it is probably the easiest thing to do, but I can't figure it out.
I would like cell A1 to pickup the last entry in row 1, will be nuberical.

I have links between multiple worksheets in a single workbook.  The
question I have is the data in a cell link over correctly but different
font color in the cell does not transfer.  Here is what I am trying to
do.  

I wonder if you can help me, I've racked my brains, but cannot find a
solution.
I have a large table of data with e.g. the following headings
Incident Number

When I copy a spreadsheet-like table that contains numbers with commas
separating the thousands from the hundreds, pasting the data into Excel
(2003 SP2) results in Excel "seeing" the commas and pasting the number
into adjacent cells so that (eg) 5,453 ends up with the 5 in one cell

Can Excel return the name of a holiday based on the date.  For example
if U4 containted the date 07/04/2006, can Excel return 4th of July.  I
realize I could do this with a VLOOKUP function and enter all the
holidays of the year in a column next to the corresponding date;