Need help in excel

[csKanna]

I have a spreadsheet (Excel 2003) with well over 40,000 records, and I'm
trying to filter it so that only records with specific information are
left. After doing this, I want to subtotal all records with identical
information in a specific field.

Here's the basic layout of my spreadsheet:

Customer        Produce       Amount
Jim Smith       apples          20
Jim Smith       grapes          100
Jim Smith       oranges         50
Jim Smith       bananas         10
Jim Smith       cherries        75
Jim Smith
Jim Smith
Jan Jones       apples          50
Jan Jones       strawberries    80
Jan Jones       pears           50
Jan Jones       bananas         30
Jan Jones
Bob Doe         apples          100
Bob Doe         oranges         50

For this example, I want to remove all records with blank fields in the
Produce column. Then, I only want to keep records with certain names in
the Produce column (apples, oranges, and pears). Finally, I want to
subtotal the Amount column while the field in the Customer column is the
same (subtotal the amounts for Jim Smith).

I really appreciate your help.

[direktoren]

Hi

For this I would recommend using autofilter instead of writing a macro...

It shouldn't take more than 1-2 minutes.

Autofilter, produce column - custom - does equal "" - delete the rows
then use autofilter - custom - equals the products you want to keep
for subtotaling, use the subtotal worksheet function.

/Nick