Advertisement
Guest User

Untitled

a guest
Oct 26th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. =INDEX(A2:A$1048576, SUMPRODUCT(MATCH(TRUE, (A2:A$1048576 <> 0), 0)))
  2.  
  3. =IF(COUNTIFS(B$2:B$11, B2, C$2:C$11, "corporate") > 0, "corporate", "private")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement