Hi Gary:
I used your macro and it worked great....now, though, I want to create a
macro to do almost the same thing, except I want it to retrieve more than 1
field of data for the person...Can I tweak this one to do what I want?

Any help with the following problem would be most appreciated:
When I Lay out the pivot table, I put:
"TRAILER #" in the row field, and it works fine.
"# of turns" in the Colum field, however When I drag the "# of turns" in

byI have set up successful SUMPRODUCT to count the number of people in a
particular job, by depot, and where the 'leave date' column is empty.
I would like to count the number of people in a particular job, by depot, by
month.

I'm a beginner with Excel so this may be a simple problem.  I'm trying to
count various items to give me a total of how many I have of each type that
I have purchased over the years,
Example:

Hello and thank you for reading.
I'm trying to get a multi-conditional count of items from my table of
data as follows:
Say a teacher has a class of students that are going to go on a field

Is there a formula function that will find 'n'th largest (or smallest)
alphanumeric field (like "Large" does with numerics).
I am trying to use formulas to move a column of alphnumeric data from one
column to another with the new column sorted alphanumerically.  To move a

I am setting up a sales receipt system for my charity and have found an
on-line one which is suitable but it has the $ sign instead of the £ sign can
I change it and if so how?

How do I protect selected cells for protection in a worksheet?
I have gone to tools and protection but can only seem to protect the full
worksheet, I have tried clicking/unclicking locked and unlocked boxes but
cant seem to get it right.

Can columns be sorted alphabetically?  If so, how?

Client has a prob where they have some staff using 2003 excel viewer and if
they
have a workbook open in veiwer, then the accounts staff can't save their
changes in the same workbook in their Excel 2002 program without having to go

I have a worksheet that has the months of the year in one column and a
dollar amount in the next column.  At the bottom I have summed the dollar
amount column.
My question:

This may be the wrong area, but thought I'd see.
Do you have a solution to tbe below?
I am trying to create a pivot table that returns only "Underwrite Now" from
another sheet but does not return "Don't Worry".

the problem I'm wondering around is that how would be the wisest or most
efficient way to create the following comparison?
Here's the background for the question:
- Rounds are 7 weeks long.

We download data from a software package that uses numbers 0,1,2,3,4 to
indicate a catagory.
0 - Salary
1- Medical Aid

Any suggestions on how to set up a formula for the below problem:
In once cell I'd like to return if true "Underwrite Now", and if false
return "Don't Worry"
Cell A1, if between 7 and 100, then return true