| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicate listing
I have a that list part numbers accross a product line I have the formula
=SUMPRODUCT((B4:O33<"")/COUNTIF(B4:O33,B4:O33&"")) counting the number of unique part numbers on this spreadsheet BUT now I would like it to create in a NEW column, say R starting at R1 the list of these unique part numbers. Can this be done with a formula/function that might help with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find duplicate records in Excel 2003 | Excel Discussion (Misc queries) | |||
| Is there a macro to identify and remove duplicate data in Excel? | Excel Worksheet Functions | |||
| Function to find duplicate values, then delete | Excel Worksheet Functions | |||
| identify duplicate data in excel spreadsheet | Excel Discussion (Misc queries) | |||
| Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
Threaded Mode
