I use Excel 2000
I have a worksheet that has duplicate (or more) entries in some columns.
When I generate the pivot table these items that are duplicated only display
once on the table and there is a blank line/s under them.

I have a spreadsheet with 2 columns: Column 1: Names, Column 2: Dates, where
each Date cell contains a comma-delimited list of dates.
For example:
Name          : Dates

I am using the following formula to compute the week number based on
the ISO standard ISO8601:2000
=INT((B4-DATE(YEAR(B4-WEEKDAY(B4-1)+4),1,3)+WEEKDAY(DATE(YEAR(B4-
WEEKDAY(B4-1)+4),1,3))+5)

I currently have a workbook that I add a new worksheet to each week.  I am
trying to track work orders - how many, if they are returned within a
suitable time frame and if work gets cancelled. My system right now is pretty
basic - download list from our database onto an excel ...

I am having trouble replacing exact cell references with named ranges in my
formulas.
Why does the following (with exact cell references) work:
=SUMPRODUCT((DOCs!P408:P701="TF")*(DOCs!O408:O701="Y"))

Is it possible to have Excel search through 1 minute raw data and be
able to determine if the price moves between a certain boundary for a
certain time then it will be classified as "Type 1". And if it is
increasing for a certain time then it will be "Type 2" and likewise

Once again I'm struggling with the 'Custom' option in Data Validation.
I have a cell formatted as 'Date' (assume A1).
I want the user to be able to enter any valid date greater than (say)
01/01/2000.

Does anyone know anything about this function?  I have been everywhere.  I
can not get it to work.  I have tried every formula I can figure out.  I even
went to the library for the Excel 2003 for Dummies book and they dont even
talk about this function. This is part of my ...

I need some help on producing this report -
The data:
Users    Clients    Run ID    Solutions    Update Solutions
Brenda    Walmart    1234    aaaa    System Generated

Hello, folks!
I'm trying to find and replace a word with another in a column containing
text.  I'm using Ctrl-H, Find = reciept (for example), Replace with =
receipt.  This locates a cell containing the word, but when I press Replace,

I need help with adding up a column of values in 'X' amount of cells, but I
don't want to include the lowest cells in the addition.
For example, I want to add cells A1:A5.  But I want the answer to eliminate
the two lowest cells out of the equation.  

Hi, I am working with Excel 2003. I have separate worksheets in
different workbooks, each sheet has various rows (from 80 to 800) and
all sheets only use 3 columns.I only use one sheet in each workbook.
I want to make a summary sheet every 4 weeks which will have all the

Is it possible to create a drop list of all the states that allows you to
pick which state you want to enter?
I will be using it with the wage entry page I have been working on just to
enter in the state that I will be working in

In the past, I have used the Data/Filter/Advance Filter tool to get
unique records based on text in a column. Is there a simple way to
obtain the nth rows in a worksheet? For example, I wish to display the
4th, 8th, 12th, 16th, etc. rows. Or perhaps the 3rd, 6th, 9th, 12th,

I am very much a novice with using Excel, I'd prefer to be doing this
in Access as that's what the data's aimed at in the long run, but the
db I'm being forced to use is not mine and I can't work that out
either - also work don't support Access so I can't use that to do the