Jul 27 2020 01:48 AM
I have a list of members with duplicate entries (different plots on an allotment). I need to find out how many unique members don't have an email address so that I know how much postage I have to buy to send them our newsletter. How do I use Unique to get the result? thanks in advance.
Jul 27 2020 04:37 AM
Jul 27 2020 06:30 PM
@mtalbot22 , I added the last name column to the formula inspired by @Hans Vogelaar :
=ROWS(UNIQUE(FILTER($B$2:$C$12,ISBLANK($D$2:$D$12))))