I would like to shade rows of my data based on whether the next cell in
a particular column has a different value from the last.
I have a list of data where one column has some duplicate values, and
to make it more readable i would like to alternately shade the groups

I am working on a labor chart. The first sheet has the names and day of the
week. I have them formatted to just put in the number of hours and it
figures pay.
There are 4 different job descriptions and at the bottom of each day, it

So, I'm creating a gantt chart in Excel and it's going OK. The formula
I'm using is:
=IF(AND(C$1>=$A$2,C$1<$B$2),"1","")
C1 is January 1st, D1 is February the first, etc. A2 is the start date

I want to make myself a little project manager. I have three major
clients. Each sends me assignments. On the first "Overview" worksheet,
I'd like to enter these projects row by row as they come in. Then there
should be three additional worksheets, one for each client. The

Not sure if this is possible, but here goes.
I'm creating a tracking report in Excel for a client. He wants to b
informed everytime there is a change made in the tracker. Is there
means of automatically e-mailing him the changed spreadsheet, once i

Hope someone out there can help, I have lost the toolbars and menu bars in
Excel, at first I thought it was showing full screen but it wasn't I then
tried to Alt/V to bring up the view menu but again nothing.  Have
re-installed Excel but still not showing, can anyone help me with ...

Anyone know of a good book that addresses the specific aspects o
Financial Analysis in an Excel based framework?
Ro
--

how can I convert a field that has an ' before the number, for example
'4578 i would like to convert it to 4578
Greg

I have got a excel report from someone which has a query link. However, i
would like to change the database that the query is looking at to a different
database. Could someone give me an suggestion ??
Thanks

I have 4 different ranges in a worksheet and need to get the effective
box/area of all four together including he areas in between the ranges so
that there is on area to reference. What is the easiest way to do this.
E.g.

Can anyone assist on how I am able to extract selected cells from other
spreadsheets into a new workbook. I have like 20 different workbooks
and want to create a macro to extract certain cells from the 20
workbooks into a new one.:confused:

I have to reorder list of numbers. Please help me to find a good way to do
that. I can't do it manually, there is actually much more numbers as in my
example.
Example:

OK, I'm having trouble with Excel. I can't get into any of the commands. Why
does it say Book 1 after Microsoft Excel at the top of a worksheet. What am I
doing wrong?

Hi - I have a single-column list of about 200 email addresses for our club.
I need to send a simple text email to all of them, using Outlook Express
(1st choice) or Outlook. Is there an easy way to convert this list of
addresses into a format that OE will recognize, without ...

IM TRYING TO GET THE SUM  FROM COLUMN A "SALES " WHICH INCLUDE THE SALES
VALUE BY USING DSUM BASED ON SPECIFIC NAME FROM COLUMN B "NAMES " AND WITHIN
SPECIFIC DATE FORM COLUMN C"DATES" ALSO BASED ON SPECIE COUNTRY FROM COLUMN
D" COUNTRIES" HOW I CAN SET THE FORM