A filter to de-dupe a portal.

UniqueValues11.zip

I didnt see this post until this morning as I had planned on posting a demo file on a new thread when I found it. This is pretty neat.

Considering that I had already created a demo last night and that this thread is on the same subject, I hope that you dont mind that I attach the demo file which updates Ugo's method slightly.

Portal_Unique_11.zip

I was thinking in the same direction - I even thought of calling this a "half-Ugo"...

Using summary fields from the self-join is a very nice idea. Thanks for posting this here.

Here's an improved version that doesn't require the relationship to be sorted by category.

UniqueValues11v2.zip

Comment, you're awesome. This is SO helpful and easy to use!

Here's an improved version that doesn't require the relationship to be sorted by category.

This is incredibly useful, thanks for posting (even if it was a while ago!)

Useful for me and so simple ! THX

hi alos for me too

just simple and easy 

thanks

On 10/30/2018 at 8:40 AM, jcm38 said:

Useful for me and so simple ! THX

hi also for me too

just simple and easy 

thanks