I'm trying to come up with something that will let me extract values in a table based on multiple criteria.
Excel.jpeg
Column P has 3 different values. I'm looking for a formula that will return the 1st non-blank unique value in column P if it matches the corresponding value in column M (which has many many different values) and am hoping that it can be modified to return the 2nd & 3rd and so on unique value in a separate cell(s).
So basically I want to be able to pull all unique Job #'s per EE #.
Bookmarks