excel小技巧

=VLOOKUP(B2,A:A,1,0)
VLOOKUP(查找值,查找范围,查找列数,精确匹配或者近似匹配)

=COUNTA(B37:B55)

=COUNTIF(F7:F34,">=20:00")

&连接字符串

posted @ 2016-11-21 18:31  Chris_在IT道路上前行  阅读(88)  评论(0编辑  收藏  举报