Hello. Now we will learn how to make a master formula to separate words from sentences. For that, I will use functions, TRIM, MID, SUBSTITUTE, REPT, and LEN. 1st step: I will change the text by replacing all the <SPACE> with …
Lesson#100: Making a master formula to separate words from the sentence Read more »
OK. I am back again with some crazy formula. Here in this post, I will show you how to make a formula to separate words from a full name. Here in this above picture, I have a list of names …
Lesson#99: Formula to separate words from a full name Read more »
So, my friend, I will here discuss an important lesson which is really required for office people. That is how to make a salary slip from an employee database. This is not about salary slips only, we can make many …
Lesson#88: How to make a Salary slip format from Employee Database Read more »
So I show you here how the logic gates can be configured in Excel. AND gate Q = A AND B So here the formula for getting AND result will be =IF(AND(J20=1,K20=1),1,0) NAND gate Q = A NAND B So here the formula for …
What is the function EDATE? UPDATE returns the serial number format date with the same day before or after a specified number of months of a specified date. Syntax of EDATE is EDATE(start_date, months) start_date: A date in a valid serial …
When you want to get the smallest or the largest number from an array then it’s just using the function MAX and MIN. But if you want to get the Kth largest or Kth smallest then there are more two …
Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest Read more »
COUNTIFS is a function to count those cells within a range which meets multiple criteria.Syntax of the function is COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) criteria_range1 – This is the first range to evaluate. criteria1 – The criteria to be used on criteria_range1. criteria_range2 – …
Lesson#68: COUNTIFS and SUMIFS function in Excel Read more »
Here I am having a list of dates. Now I will show how to count cells in Excel having values between two dates. So I made here a list of months from Jan-18 to Dec-18. Then I have put this …
Lesson#67: Count cells in Excel having values between two dates Read more »
Here I will discuss three functions COUNT, COUNTA, and COUNTBLANK, and show their similarity or difference. COUNT COUNTA COUNTBLANK Description The COUNT function counts the number of cells that contain numbers The COUNTA function counts the number of cells that …
Lesson#63: COUNT, COUNTA, COUNTBLANK explaination Read more »
This sheet can calculate the value of your name or any word by summing every letter in alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more »