filmov
tv
Excel | Multiple Criteria using INDEX & MATCH #exceltricks #excel #cheatsheets #programming #shorts
Показать описание
Here is how to use Multiple Criteria using INDEX & MATCH
=INDEX(sales[Date],
MATCH(G2&H2,
sales[Name]&sales[Region],0)
)
#exceltricks #excel #cheatsheets #programming
=INDEX(sales[Date],
MATCH(G2&H2,
sales[Name]&sales[Region],0)
)
#exceltricks #excel #cheatsheets #programming
0:05:51
0:04:25
0:03:24
0:00:48
0:04:11
0:00:57
0:15:23
0:00:34
0:05:58
0:00:55
0:09:52
0:04:53
0:03:30
0:00:18
0:00:30
0:05:23
0:01:00
0:02:01
0:00:57
0:00:25
0:14:04
0:10:22
0:00:43
0:00:40