0

Filter Duplicate Row

Zulfadzli

May 18, 2023 06:40

None

Follow

Hello Everyone, 

Seeking your expertise. I want to filter rows that are duplicate. below sample

Item No.      Lot No.

A1                  A01

A1                  A02

A1                  A03

 

Expectation

Item No.         Lot No. 

A1                  A01,A02,A03

 

my line is:

=NL("Rows","Sales Shipment Line","Item No.","Lot No.",$F23)

I also tried this :

=NL("Rows","Sales Shipment Line","Item No.","Lot No.",$F23, "IncludeDuplicates=","False")

it still dont work and column item no. duplicate. Kindly need you guys help. Thanks 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  CascadiaDataworks May 18, 2023 14:41

  You would use the same technique that someone previously answered for you.

  You need a rows replicator for the item numbers:=NL("Rows","Sales Shipment Line","Item No.") then

  =NP("Join",NL("Filter","Sales Shipment Line","Lot No.","Item No.",<<REFERENCE ITEM NO.>>),",")