Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. =MAX(SI(Y(F:F="llave1";P:P=10);L:L))
  2.  
  3. sesionesMes = WorksheetFunction.Max( _
  4. WorksheetFunction.IF( _
  5. WorksheetFunction.And(Columns(7) = llave, Columns(16) = mes), _
  6. Columns(12) _
  7. ) _
  8. )
  9.  
  10. sesionesMes = WorksheetFunction.MaxIfs(Columns(12), Columns(7), llave, Columns(16), mes)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement