Count Visible Rows in a Auto-Filtered List

When you apply an autofilter to a table or a cell range, you can use the SUBTOTAL function to count just the visible rows. The SUBTOTAL function is multiple functions built in one function with different methods (AVERAGE, COUNT, COUNTA, MAX, MIN, SUM, etc). In this...

5 Lesser Known Excel Features to Boost Productivity

As we all know, Excel is a very useful application that has many features. You can use Excel to do things like a building a database, a data entry sheet, creating pivot table and more. Because there are way too many features in Excel sometimes it can get a little bit...

3 Ways To Work With Duplicate Data in Microsoft Excel

Sometimes when we perform data entry task, or copying data from somewhere, we occasionally encounter the issue where some data are duplicate. Unfortunately, In Excel, dealing work duplicate records aren’t that difficult.In this tutorial, I will show you 3 ways...

Format Date To Quarter and Year

In Excel, there no built-in formatting that converts date as quarter (plus year). In this quick video, I will show you how you can easily format dates to quarter and year in Excel using simple formula. data-ad-layout="in-article" data-ad-format="fluid"...

Perform a Lookup Based On a Value Between Two Values

By default, when you perform a look up (VLOOKUP or INDEX/MATCH) in Excel, you can only match a value either by exact match or approximate match. If you want to look up a value in a range or between two dates, you can use something called array formula. In this...