Filter Duplicate Row

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



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 

1 comment

Please sign in to leave a comment.