COUNTA: An overdue celebration of one of Excel’s best functions

/in /by

COUNTA is an unsung hero. It’s not likely to show up on anyone’s Top 10 Excel functions or features. Yet, COUNTA does a lot!

In this video I show multiple ways that COUNTA continues to be a favorite of mine–even with the glamorous features like XLOOKUP, Power Query, Dynamic Arrays, etc. You’ll see:
– COUNTA helps determine the size of a job before we get started.
– COUNTA helps measure progress.
– COUNTA in conjunction with the new dynamic array function, UNIQUE, gives us insight into our customers.
– COUNTA and RANDARRAY help create fake data for use in training or exploration.

Join the party! Let’s celebrate COUNTA!

#COUNTA
#ExcelCelebration

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2