I'm hoping someone can help me figure this one out.  Each day I ru
a report of material to purchase, which is saved in an Excel workbook.
Depending on the status of each item (row), I color code the row.  
varying percentage of each day's items are carried over to the nex

Hi, I have a field named "Postal" at the top of column F that always include
a number with 5 digits then a city name then a region name, such as "11090
CARCASSONNE Linguadoca-Rossiglione". I need to create a program to have this
field changed as following : "F-11090",  then ...

I'm able to check for single cells like:
=A1=B1
But how do I do it so I can check if A1 equals from B1 to B10 ? For
example, A1 is:

Scenario: Sheet with db output regarding product sales. Second sheet w/
trend line formulas to predict how many to order for the next month.
Works fine.
Here's the poblem. Lets say it predicts I sould purchase 4 bottles of

I have a long list of details with one column listing the dates of birth in
the UK format. For example someone born on May 25th 1988 would be recorded
as 25/05/88. I want to add another column with the birth month being
recorded as May (or 05). How do I turn '25/05/88' into ...

I use a lot of H/V- lookup. One of the problems I run into is that the
auto-fill doesn't change the individual number references to rows or
columns, only cell references. To get around this I usually hide on the
page I'm working a simple column that counts 1 to whatever and then

I wonder if I can do a count on a specific value, like if I had this:
CAR1
CAR1
CAR2

Excel 2003
I am selecting a column of 1 digit whole numbers to get the average total.
Instead of a "4" I get 4.1.1.1. I only want the "4".
Is this adjustable?

I have a spreadsheet with a list of outlet names and various associated
information.  I want to have an alternating background colour when the name
changes.  For example
Name        Details

Is there a way (beside writing a macro) to delete if  you have identical
entries in a column and you want to keep only one copy of that row.  For
e.g.
A  B  C

I have to columns, alphabetically sorted, one with 1oo names, one with 8o-9o
names, which are identical to the ones in the column with 1oo.
Is there a way (formula or macro) that places the identical text (names)
next to each other in the same row, leaving blank the cell where ...

=VLOOKUP(G2,$C$30:$F$369,2)  
I have managed to create a look up table using the office assistant, and the
formula above dumps information into cell G3. If G2 is empty or has a zero I
don't want G3 to have anything in it. At the moment it just keeps coming up

I have excel sheet with text in it.
I have to export or save it as csv file so that all the columns are
separated by comma and values in columns are enclosed in quotes.
The csv file should be like:

How to return workdays by using a formula as mentioned below?
Networkdays function exclude weekend days... i would like to include
weekenddays (saturday) also.
 Date        workday

I have many workbooks which have 8-9 sheets each. All identical as an
e.g each work book represents a company and each sheet has some
financial data for that company.
I am adding  a new sheet which has charts and formulas which refrence