Quote Originally Posted by micope21 View Post
Hi

See the file!
It a array formula

Press same time Ctrl+shift+enter,NOT ENTER copy down

Regard
micope21
Okay I appreciate the help and tried using your sheet but they Owner name is sill repeated. I tried adding the rest of the rows but still it seems as if there is no filter/formula that. require just one instance of the Owner name and One instance of the EDU.

The result should be around 10 different Owner names from the example along with the one instance of the EDU. (10 and 10)
Sort of like using the filter but I can't loose the EDU from the rows unless that EDU in that row was repeated more than once. I can only add that EDU with the matching owner name once. If the owner name is repeated ten times but has the same EDU then the EDU is not added to anything since the EDU was repeated. The only time it does add is when the EDU is different.