Excel FILTER Function: Retrieve All Matches Not Just the First - видео

The FILTER function in Excel is a powerful semi-new function that allows you to retrieve ALL Matches based on specific criteria. Unlike XLOOKUP VLOOKUP or INDEX MATCH which only return the first instance of a matched value the FILTER function can return all instances. Whether youre looking for all instances of a specific value or applying multiple criteria to your search the FILTER function has got you covered. ? My Online Courses The Excelerator Course ? Subscribe to make sure you do not m...
Источник видео: RuTube.ru (Обучение)