View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
huntin_Xcel_answers
 
Posts: n/a
Default 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?