LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Lookup and Display Multiple Unique values based on criteria

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unique values with multiple criteria Rick Excel Worksheet Functions 4 February 13th 09 02:24 AM
Sum unique values based on criteria yshridhar Excel Worksheet Functions 4 April 29th 08 05:29 AM
Count unique values based on multiple criteria Nip Excel Discussion (Misc queries) 2 November 2nd 06 03:41 AM
how to count unique values in excel based on multiple criteria IDBUGM Excel Worksheet Functions 3 March 15th 06 04:00 PM
how to count unique values in excel based on criteria Jorge Excel Worksheet Functions 2 April 13th 05 02:56 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"