I am setting up a work form and want to use an array forumla to match a column of the page and show it only once (when duplicates).

I enclosed an example. I want to match the work code based on two criteria and show the unique matches.

Thanks for the help



Work Code Array.xlsx