FILTER GOAT CalCPA Article

Question: What is the best Excel function? Typical responses are VLOOKUP, INDEX, MATCH, XLOOKUP and SUMIFS, which are among Excel’s highlights.

Follow-up question: If there was a function that could do the work of these, would it be the Greatest of All Time (GOAT)?

Well, the FILTER function is too new to declare it the GOAT, but it certainly has the potential to be one of the greatest Excel functions ever.

Check out the full CalCPA article for the details.

Posted in ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Stay Connected

If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.

Want to learn Excel?

Our Campus Pass includes access to our entire Undergrad and Masters catalog. Gamification ensures it is the most fun you can have learning Excel :)

2 Comments

  1. James Fye on November 11, 2020 at 12:56 pm

    Your knowledge of Excel is phenomenal. I’m surprised at the lack of knowledge that current college graduates have about, in my opinion, one of the most fantastic programs available in the market place that is a must for CPA’s or anyone working with statistical data.
    I’m just super impressed with your abilities in Excel and it is a constant reminder about how little I personally understand this software.
    Thank you for your spreading your knowledge. I have purchased “Excel University Volume 1” and use it as a resource guide often

    • Jeff Lenning on November 12, 2020 at 10:10 am

      Thanks for your kind note James … I really appreciate it! Excel is a big place, and I learn stuff about it all the time. And when I do, I love talking about it 🙂

Leave a Comment





For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.