Eliminating Duplicates with a Formula Query

I have been able to participate in the Beta for Formula Queries.  Best I can figure not all of the features that were shown at EMPOWER are live in Beta, but these three functions are, which were provi...