Course Description:

You’d like to do a VLOOKUP but return ALL match results instead of just the first match? You can use Excel’s new FILTER function. What if you’d like to lookup multiple criteria and return ALL match results? You can use the new Excel Dynamic Array FILTER Formula! It’s like the dynamic or automatic version of Excel’s advanced Filter feature. You can return Filtered results based on AND as well as OR conditions. The Excel Filter function filters your data based on criteria, and returns all the matching records. This can be one or more records. If more than one match is found, the results will “spill” vertically. If there is a blockage (i.e. your results are spilling into already filled cells) then you will get the #SPILL error. You can easily get rid of this error by removing the cells that are blocking the FILTER formula. If FILTER doesn’t find any matching records it will return a #CALC error. You can suppress this error with the text or value of your choice by adding this to the last argument of the FILTER formula. Course Length: 9:21 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.