Microsoft Excel has introduced some new functions in 2022. One of them is the Excel VSTACK function. What is the Excel VSTACK function? Description Excel VSTACK function vertically and sequentially appends arrays to produce a larger array. …
Lesson#157: What is the Excel VSTACK function? | How does VSTACK work in Excel? Read more »
Hello Reader! Welcome to my other post on Excelabcd. Microsoft Excel has introduced a new function on Excel 365 and Excel online version. Which is the Excel XLOOKUP function. Which is the DAD of all LOOKUP functions. Here we shall …
Lesson#156: XLOOKUP vs VLOOKUP in Excel. Which one is better? Read more »
Hello readers! In this post, we shall learn about the 25 most useful Excel Functions everyone needs to know. Newcomers who start to learn Microsoft Excel gets easily confused with hundreds of excel formulas and functions. So today we shall …
Lesson#155: 25 most useful Excel Functions everyone needs to know Read more »
Today I am going to discuss how to write all numbers in a minimum of four digits or three or five. It’s a very common question that people often ask on Excel forums. I shall share two easy methods to …
Lesson#150: how to write all numbers in a minimum of four digits? Read more »
Hello guys! I am back with a new lesson. Here I will show you to make a formula that can make a mirror of an excel table. Here I have made a table with some data. I will make a …
Lesson#143: How to make a mirror of a table in excel Read more »
In this post, I will show you to make two new functions. These are functions MAXIF and MINIF. It means this formula will show the Maximum or the Minimum value when the criteria will be matched. Here I have put …
In this post, I will show you the trick to make the function SUMPRODUCTIF. We have the SUMPRODUCT function in excel. But how to make a SUMPRODUCT function that follows criteria like SUMIF? Here I have made an example. Here’s …
Lesson#132: How to make the function SUMPRODUCTIF Read more »
Here I will show how to make auto arranged serial no when you filter a column. This post will be very useful to many excel users like me. Suppose you are using a data sheet and you need to filter …
Lesson#128: Formula to make serial no auto arranged when filtered Read more »
Here I will show you a nice trick to split up characters of text in excel. You can see in the above picture I am having a merged cell to put a text in it. I will develop a formula …
Lesson#117: How to split up characters of text in excel Read more »
Here I will share general tips about Conditional Formatting and some Information functions. These functions are ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT. You can use these functions to highlight the specified types of values among an array. ISBLANK function highlights blank cells among an array of …
Lesson#115: Information functions with Conditional Formatting Read more »