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?
|