I need a formula so that I can type in a part number on the other worksheet
and generate summary data on all the entries for that part number.

"Ashish Mathur" wrote:

Hi,

Use advanced filters. Since you want to filter the data to another sheet,
your active cell should be on the worksheet where you want the output. Then
run advanced filters. Also, check the box for unique records only.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MPI Planner" wrote in message
...
I have a rather massive list of entries that I need to analyze. I am
looking
to on sheet 2 list all of the operator clock numbers [once only] that run
a
given part number from the data in sheet 1. On sheet 1 the Employee #'s
are
listed in Column B rows 1 thru 45,000. The Part ID's are listed in Column
C,
same rows. There are multiple parts and multiple entries of the same
operator
running the parts. In sheet 2 I am looking to enter a Part ID in cell A1
and
then A2 down would list employee clock numbers
Example

A1: Product 629
A2: 0006
A3: 0124
A4: 0156

Even if operator '0124' ran 'Product 629' 300x's I only need it listed in
this list once.