Excel UNIQUE function has been recently introduced by Microsoft. It’s a very good function and method to remove duplicate values in Excel. So in this post, we shall discuss the function and I shall show you some examples. What is …
Hello friends! I hope you all are very well. Today we shall go a little outside of Microsoft Excel. Don’t be disappointed, and I am talking about the brother of Excel, Mr. Word. Yes, I am going to discuss the …
Lesson#164: How to easily create a mail merge in Word from Excel – step by step Read more »
Microsoft Excel has introduced some new functions in 2022. Here are 6 of the new excel formulas among all of them. Today I shall discuss 6 new Excel lookup and reference functions CHOOSECOLS, CHOOSEROWS, HSTACK, VSTACK, DROP and TAKE. What …
Lesson#163: 6 new excel formulas must know in 2022 Read more »
Microsoft Excel has introduced some new functions in 2022. Two of them are the Excel TEXTBEFORE and TEXTAFTER functions. What is TEXTBEFORE function? Excel TEXTBEFORE function Returns text that occurs before a given character or string. Syntax TEXTBEFORE(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found]) …
Lesson#162: What are TEXTBEFORE and TEXTAFTER functions in Excel? Read more »
Maximum Microsoft Excel users frequently ask this question about Excel. One of the most asked questions about Excel is, “How to remove duplicates in Excel?” or “How to delete duplicates in Excel?” or “How do I delete duplicates in Excel …
Lesson#161: How to remove duplicates in Excel? | 5 ways to delete duplicates in Excel Read more »
In this post, I am going to discuss on INDEX – MATCH combination. How can we make an efficient lookup function combining these two functions? I shall also discuss the comparison of INDEX – MATCH with VLOOKUP. What is the …
Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP Read more »
Microsoft Excel has introduced some new functions in 2022. One of them is the Excel TEXTSPLIT function. What is the TEXTSPLIT function? This function works like the Text to Column feature in Excel. This feature splits texts across columns or down …
Lesson#159: What is Excel function TEXTSPLIT? TEXTSPLIT vs TEXTJOIN comparison. Read more »
Microsoft Excel has introduced some new functions in 2022. One of them is the Excel HSTACK function. What is the Excel HSTACK function? Description Excel HSTACK function horizontally and sequentially appends arrays to produce a larger array. This …
Lesson#158: What is the Excel HSTACK function? | How does HSTACK work in Excel? Read more »
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 »