In this tutorial, we will learn different ways to Copy and Paste in Excel VBA. Copy and paste are some of the most frequently used activity in Excel. For copying the data in Excel, select the dataset, which you want to copy and use the keyboard shortcut (CTRL+C), and then go to the destination location, …
Copy and Paste in Excel VBA: 4 Easiest Way (For Beginners) Read More »
Basically, this function sums the values in a cell or range of cells. Which includes numbers, cell references, ranges, arrays, and always skip text values or blank cells.
This tutorial describes the formula syntax and usage of the Excel COUNTIFS Function and its usages. Excel COUNTIFS Function – Definition Excel COUNTIFS function is a member of the COUNT family and advance version of Excel COUNTIF Function. This function is a combination of two functions, “COUNT” and “IFS” two functions. Separately both of them …
How to Use Excel COUNTIFS Function with Multiple Criteria Read More »
In this blog post, you will learn about one of the most useful and underused features of Microsoft Excel which is known as Format Painter. See the image below:- What is Excel Format Painter? Excel Format Painter is used to copy a multi-formatted dataset and apply that formatting into a different dataset. Suppose that a …
Excel COUNTIF Function is a member of the COUNT Family and is a combination of two functions, COUNT and IF function. In this blog post, you will learn about many examples or uses of the Excel COUNTIF function, such as find any particular number within a given range or date or text and so on. …
How to Use Excel COUNTIF Function – with Multiple Condition Read More »
In this tutorial, we will learn about Excel COUNTBLANK Function. This function is a member of the Excel COUNT Family but for different use. Definition of Excel COUNTBLANK Function Excel COUNTBLANK function counts only blank cells in the data set. If there is any space within the cell, this function will not consider this as …
Excel COUNTBLANK Function – An Introduction Guide Read More »
In this blog post, we will learn about “how to create a custom auto fill list in Excel 2013”. What is a Custom AutoFill List? Suppose that we want to write a month’s names from January to December. So, for that, we type “January” only and drag down till December. All the names drag automatically. …
How to Create a Custom AutoFill List in Excel 2013 Read More »
In this blog post, we will learn about Excel COUNTA function. This function is a member of COUNT family of Microsoft Excel. Explanation In simple words, Excel COUNTA function counts every cell value which is not blank. This function counts each non-blank cell value as “1” and skips blanks. In the previous blog post, we …
Excel COUNTA Function – How to Use (with example) Read More »
Excel COUNT function is a very basic and built-in function of the Excel COUNT family. This function counts only numeric values and skips the text ones. Suppose that we want to make a count of a range (B2: B6) i.e. (1, 5, 7, a, b) and apply COUNT function =COUNT (B2: B6) and our result …
Excel COUNT Function – How to Use (with example) Read More »