Fórmula FILTRO no Excel é melhor que PROCV 👍 2, 3, 4 critérios e Exemplos Práticos

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵FREE DOWNLOAD EXCEL SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this free Excel video lesson, we will learn how to use the filter function or filter formula in Excel. The filter function in Excel is better than VLOOKUP, XLOOKUP, HLOOKUP, LOOKUP, INDEX MATCH, because the filter function can return multiple results at once, while the other functions only return one result at a time. The filter function can return multiple repeated results, returns repeated values, returns multiple search criteria, and multiple search conditions in the Excel table. It is a dynamic and interactive formula that can help us perform analyses in Excel, create reports and automate tasks, saving time in our daily routine. You can use the filter function in several different situations, such as in a sales spreadsheet, a purchasing spreadsheet, an inventory control spreadsheet, a logistics spreadsheet, an accounts payable spreadsheet, etc. We can use the plus sign or the asterisk sign to use different criteria within the filter formula in Excel. We can combine search criteria so that it only returns the desired information that is all within the same line, or perform a more comprehensive search using the plus sign to return everything we searched for, even if they are not all on the same line. We can use specific searches with the conditional and (asterisk) and comprehensive searches with the conditional or (plus symbol). #ExcelenteJoão #Excel #Dashboard