If you are required to add particular numbers with specific length in a range then you can make use of data validation. In this article, we will focus on extensive use of data validation custom feature to allow user to … Continue reading
If you are required to add particular numbers with specific length in a range then you can make use of data validation. In this article, we will focus on extensive use of data validation custom feature to allow user to … Continue reading
How to Replace a Particular Character with Number in Microsoft Excel If you are looking for a formula to replace a particular character on specific position with a specific number then this article is for you. In this article, we … Continue reading
In this article, we will create a custom function to calculate the sum of numbers in cells in the range having defined color. For this example, sample data consists of sales team data. Sales team data contains details related to … Continue reading
In this article, we will create a custom function to count the number of cells in the range having defined colors. For this example, sample data consists of a range which has values ranging between 100 and 1000. Values in … Continue reading
In this article, we will create a custom function to count the unique values in the defined range. Raw data for this example consists of random numbers in the rows. In this example, we want to count the number of … Continue reading
In this article we will learn how to specify text in another cell, if a cell contains certain text in Microsoft Excel. We will use the combination of IFERROR, IF and SEARCH function. Let’s take an example … Continue reading
In Excel we have lots of functions, in which COMBINA function is one of the Math & trig function. This function has been introduced with Excel 2013. It returns the number of combinations, with repetitions, for a given number of … Continue reading
In this article, you’ll learn how to indicate for maximal and minimal values within a range value in Microsoft Excel. Let’s take an example to understand:- We have students score data, in which we want to find out minimum … Continue reading
Problem: We want to use variable-rate Taxable Income Brackets to calculate a person’s total income tax. Solution: Use the INDEX, MATCH, and LOOKUP functions as shown in the following formula: =INDEX(TaxTable,MATCH(C13,Bracket),3)+(INDEX(TaxTable, MATCH(C13,Bracket)+1,2))*(C13-LOOKUP(C13,Bracket)) Screenshot // Calculating Total Income Tax
SKEW.P Function Excel 2013 has introduced a new function i.e., SKEW.P function. This function returns the skewness of a distribution based on a population. Syntax:- SKEWP(number 1, [number 2],…) where number 1, number 2 are the reference to … Continue reading
