Advertisement
Guest User

Untitled

a guest
Jul 10th, 2015
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. B1: 7/18/15, K1: someone1@emailhost.com
  2. B2: 7/18/15, K2: someone2@emailhost.com
  3. B3: 7/18/15, K3: someone3@emailhost.com
  4. B4: 7/18/15, K4: someone4@emailhost.com
  5. B5: 7/18/15, K5: someone4@emailhost.com
  6.  
  7. B7: 7/19/15, K7: someone5@emailhost.com
  8. B8: 7/19/15, K8: someone5@emailhost.com
  9. B9: 7/19/15, K9: someone6@emailhost.com
  10. B10: 7/19/15, K10: someone6@emailhost.com
  11. B11: 7/19/15, K11: someone7@emailhost.com
  12.  
  13. P6: 7/18/15
  14. Q6: 4 (using this formula: =SUMPRODUCT((K1:K5<>"")/COUNTIF(K1:K5,K1:K5&""))
  15.  
  16. P12: 7/19/15
  17. Q12: 3 (using this formula: =SUMPRODUCT((K7:K11<>"")/COUNTIF(K7:K11,K7:K11&""))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement