Help! :confused:
I’m looking to create a conditional format on a cell which states an
agent’s name that will flag Red! Sounds easy yes! however I need it to
flag red only if they have three consecutive values in different

i need a formula that can tell me the last time that a client placed an order
w/ my company
all of our clients place multiple orders with us over the span of the year,
and many clients names are in the workbook. the formula needs to be able to

I have used sheet names as part of my formula, however, I have other
sheets with the same design.  I have made a copy of the sheet, but it
carries the original sheet name.  Is there a way of using the find and
replace feature to change the sheet name in the formula e.g. sheet1!a10

Work four summers, starting at age 16
Save the income in a Roth IRA account
Invest it in a simple, low-cost equity portfolio
Simmer slowly for 47 years

How do I find the equation editor toolbar and display it in Excel?

Hi to all.
In a pc with XP installed, pressing enter after entering 1, the result
is 100. Two zeroes are added automatically.
Selecting "Format"- "Cells" I found:

How do I get a cell to reflect the value which lies in a sheet's tab (the
sheet name) without having to manually type it in

All,
I have a need to create an alphanumeric value that is a combination of two
alpha values and an incremented number off of existing data.  For instance:
ABC-XYZ-001

I have a spreadsheet that links to 3 worksheets in the current,
immediately previous, and immediately succeeding day.  Two of the
formulas I currently have are:
='P:\Volume Logs\month 2006\[prevdate.xls]Production Summary'!$E$20

Given a set of rows each cell containing a value is there a way to return a
new range based on those values without duplicates?

I've learned that Indirect only works in referencing another workbook
when that workbook is open.
Is there a way to have a list of references to external workbooks that
can be selected from a validated list that would then reference a

I want to be able to open a workbook and be able to see all the worksheets
within it, but I want all other users to open the worksook and see only 3 of
the worksheets.
Is there some way of protecting the workbook to make this happen?

I am trying to filter a list to show only rows that contain a number
ending in a specific digit.  The problem I've encountered is the
numbers have 2 deciaml places and I cannot determine how to set the
criteria.

Any help with this would be greatly appreciated.
I am running Excel 2003 on a normal laptop as part of Office Professional,
on Windows XP Professional.
I recently installed (successfully it seemed) an Excel add-in:

Hi
I am trying to write a formula that will enter the date in field A2 if there
is text in B2 but the date must be the date when B2 was typed into and not
todays date.any help will be appreciated.