| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unique values
I need help for returning unique values. I can count the unique values but I
need to show them. For each different ManDocNo, I want to return the unique EPACodes. A simplified example below: ManDocNo EPAUCode EPAPCode EPAD1Code 24155580 24155580 D009 24155580 24155580 U151 D009 AR1599445 AR1599445 AR1599445 AR1599445 AR1599445 AR1599445 D001 AR1599445 U019 D001 AR1599445 D002 AR1599445 P087 AR1599445 P105 AR1599445 U006 D001 AR1599445 U019 D018 AR1599445 U031 AR1599445 U044 D022 AR1599445 U053 D001 AR1599445 U057 D001 AR1599445 U092 D002 AR1599445 U103 D002 Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print unique values | Excel Worksheet Functions | |||
| unique values in a cell base on another cell | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Charts and Charting in Excel | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
