Let’s see how to shuffle the records of a dataset using the RAND, LARGE, ROWS and VLOOKUP functions in Excel. Step 1: Insert a column on the left side of the dataset and generate an array of random numbers in it. The RAND Function in Excel can be used for this purpose. =RAND() Step 2: … Read more
Following are 4 different methods in Excel to find the ‘Day Name’ corresponding to a ‘Date’. 1. TEXT Function to find Day Name from Date The TEXT function in Excel can be used to return the corresponding Day Name, Month or Year from a Date. The following formula will return Tuesday, the Day name corresponding to the … Read more
3 different methods to display formulas used in an Excel worksheet. Method 1 Go to the Formulas tab in the Excel ribbon, Click on Show Formulas Once you click on this button, every cell in the worksheet will display the formula used in that cell, instead of the resulting value. To turn off of this … Read more
Calculate the Square of a Number The following are 3 different formulas to calculate the Square of the number in the cell B3 Formula 1 =B3*B3 Formula 2 =POWER(B3,2) Formula 3 =B3^2 Calculate the Square Root of a Number The following are 3 different formulas to calculate the Square Root of the number in the … Read more
Have you ever thought of an Excel formula that will convert Numbers to Words? i.e. A formula that can convert the number 456,571 into Four Hundred and Fifty Six Thousand Five Hundred and Seventy One. In this blog post, I am sharing two Excel formulas that can convert Numbers in Words. Pete M’s Formula =CHOOSE(LEFT(TEXT(A1,”000000000″))+1,,”One”,”Two”,”Three”,”Four”,”Five”,”Six”,”Seven”,”Eight”,”Nine”)&IF(–LEFT(TEXT(A1,”000000000″))=0,,IF(AND(–MID(TEXT(A1,”000000000″),2,1)=0,–MID(TEXT(A1,”000000000″),3,1)=0),” … Read more
You are given the X, Y Coordinates of 2 points, (99.5,39.5) and (201.1,45.7) and asked to find the Y coordinate of an intermediate point with an X coordinate of 115.7. How will you solve this problem? The answer is Interpolation! Interpolation is the method of estimating ‘unknown values’ that fall between ‘known values’. In this … Read more
In this blog post, I will explain two Excel formulas that can be used to pick a random value from a List. Following is a list of 6 contestants for a particular game. For each round of the game, a player should be randomly selected from this list. Let’s see how to pick a random … Read more