filmov
tv
Remove duplicates for certain criteria using Excel's Advanced Filter
Показать описание
00:00 Advanced Filter options in Excel- more options than Filter
00:36 Difference between standard filter and Advanced Filter
00:53 Simple Advanced Filter- extract unique records only from list
02:06 Add criteria to the advanced filter
How to use the Advanced Filter in Excel to remove duplicates especially where you also want to include criteria e.g. show me all the unique sales where product A was bigger than 500 AND product B was bigger than 500.
00:36 Difference between standard filter and Advanced Filter
00:53 Simple Advanced Filter- extract unique records only from list
02:06 Add criteria to the advanced filter
How to use the Advanced Filter in Excel to remove duplicates especially where you also want to include criteria e.g. show me all the unique sales where product A was bigger than 500 AND product B was bigger than 500.
0:03:14
0:08:56
0:00:25
0:06:57
0:11:41
0:03:46
0:00:43
0:02:23
0:00:27
0:02:04
0:01:09
0:08:40
0:02:39
0:00:12
0:28:14
0:06:43
0:00:26
0:04:12
0:02:25
0:02:05
0:00:20
0:00:02
0:02:04
0:04:54