Hi,
Required a formula help to return and extract a distinct and duplicate items list separately from a two different lists as per data list-1 contains column A & B, List-2 data contains in Column D & E.
Sample sheet attached with desired results.
Thanks,
Bookmarks