Enter Details

Comment on stories, receive email newsletters & alerts.

This is your permanent identity for Business Insider Australia
Your email must be valid for account activation
Minimum of 8 standard keyboard characters


Email newsletters but will contain a brief summary of our top stories and news alerts.

Forgotten Password

Enter Details

Back to log in

How To Use Microsoft Excel To Pull Only The Data You Need From A Set

Oftentimes, you’ll have a large amount of information that you only need to know one thing about.

Maybe you have a list of students, and only want to know how many of them got A’s. The easiest and simplest way to evaluate this kind of information is using the COUNTIF function in Excel. Click for sound.

Business Insider Emails & Alerts

Site highlights each day to your inbox.

Follow Business Insider Australia on Facebook, Twitter, LinkedIn, and Instagram.