Subtotal Function Archives - Page 2 of 4

How to Count Unique Values in Filtered Column in Excel (5 Methods)

May 26, 2022 Excel Formulas 1

If you have a larger dataset and you need to apply filters in columns. More importantly, you might require to count only unique values except for the ...

How to Auto Number Cells in Excel (10 Methods)

May 25, 2022 Excel Basics

There are various ways to auto number cells in Excel. Auto numbering cells mean filling the cells automatically with numbers in Excel. Here we will ...

How to Count Cells with Specific Text and Fill/Font Color in Excel (4 Ways)

May 25, 2022 Excel Formulas 1

It's possible that you'll need to count cells based on specific text or formats, such as fill color and font color. Furthermore, you may be required ...

How to Count Only Visible Cells in Excel (5 Tricks)

May 25, 2022 Excel Formulas

Sometimes, In excel, we need to count only visible cells. For instance, when you apply a Filter to excel data, certain rows become hidden. Besides, ...

Excel Formula to Count Colored Cells in a Row (2 Effective Methods)

May 25, 2022 Excel Formulas

In this article, we will learn to count colored cells in a row with an Excel formula. Sometimes, we need to use colors to highlight certain cells in ...

Count Cells by Color with Conditional Formatting in Excel (3 Methods)

May 25, 2022 Excel Formulas

We may sometimes need to count the Excel cells by Color. That is not hard to do. But, things get complicated when we try to count the cells by color ...

How to Count Filtered Cells with Text in Excel (3 Methods)

May 25, 2022 Excel Formulas

We may sometimes need to count the Excel cells with text for different purposes. That is not hard to do. But, things get complicated when we try to ...

VBA to Copy Excel Worksheet to Another Workbook without Formulas

May 25, 2022 Macros & Excel VBA

In Excel, we often need to copy a worksheet to another workbook without formulas with VBA. We can use both the context menu and VBA for this. Today, ...

How to AutoFill Numbers in Excel with Filter (2 Methods)

May 25, 2022 Excel Basics

We often need to work with huge datasets in Excel. AutoFilling numbers with Filter can make our task much easier. So, we should know how to AutoFill ...

Excel Formulas to Fill Down Sequence Numbers Skip Hidden Rows

May 25, 2022 Excel Basics

Sometimes we need to hide some unnecessary rows in Excel to present the information. There we frequently face a problem filling down the sequence ...

How to Auto Number or Renumber after Filter in Excel (7 Easy Ways)

May 25, 2022 Excel Basics

We often use Filters in Excel to sort data. Sometimes we may need to arrange data from smaller to bigger or vice versa. It is tiresome to arrange ...

How to Calculate Percentage in Excel Based on Cell Color (4 Methods)

May 25, 2022 Excel Basics

Sometimes, in our Excel worksheet, we need to calculate the percentage based on cell color. In this article, we’ll show you the simple methods to ...

How to Calculate Percentage Based on Conditional Formatting (6 Ways)

May 24, 2022 Excel Basics

Depending on different conditions you may sometimes highlight some rows using Conditional Formatting and then you may need to calculate percentage ...

How to Hide Columns in Excel with Minus or Plus Sign (2 Quick Ways)

May 25, 2022 Excel Basics

In this article, we will learn how to hide columns in excel with a plus or minus sign. Sometimes, we need to hide columns for performing different ...

How to AutoFill Ascending Numbers in Excel (5 Quick Ways)

May 24, 2022 Excel Basics

We need to AutoFill Ascending Numbers in our Excel worksheet very often. In this article, we will show how you can autofill ascending numbers easily ...