Excel 2013
I am trying to calculate the following values. The spreadsheet is attached.
Unique Emails 7 (formula I am using is below)
count of phones without emails (answer is 1)
count of UNIQUE emails without phones answer is 3
count of UNIQUE emails with phones answer is 4
Column A Column B
[email protected] (212) 888-8888
[email protected]
ddd@gmail
[email protected] (203) 555-1212
[email protected] (203) 555-1212
(312) 888-2222
[email protected]
[email protected] (212) 999-7777
[email protected]
[email protected] (312) 444-2222
=SUM(IF(FREQUENCY(IF(LEN(A6:A15)>0,MATCH(A6:A15,A6:A15,0),""), IF(LEN(A6:A15)>0,MATCH(A6:A15,A6:A15,0),""))>0,1))
Bookmarks