You are reading the article How To Quickly Transpose In Excel? Methods With Examples & Templates updated in December 2023 on the website Daihoichemgio.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 How To Quickly Transpose In Excel? Methods With Examples & Templates
What is Transpose in Excel?Transpose in Excel refers to a feature that allows you to flip the orientation of data in a selected range of cells, from rows to columns or from columns to rows. This means that data displayed horizontally in a row will be rearranged vertically in a column and vice versa.
For instance, if we apply the Transpose feature in Excel to the vertical table below, it would be converted into a horizontal table. Also, the column heading is transformed into a row heading, and the data from each column is transferred into the respective rows.
Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & others
This feature is especially useful when the data presentation format is inconvenient, making it difficult to analyze or visualize effectively.
Transpose in Excel SyntaxThe Transpose syntax is as follows:
Array: It is the data (table) we want to transpose from one form to another.
Key Highlights
The Transpose function can be applied to a single cell, a range of cells, or an array.
When a table or array is transposed, the data in the first row is moved to the first column of the new table. The second row is moved to the second column, and so on.
The number of rows in the new table must be equal to the number of columns in the original table and the same number of columns as the old table has rows.
The Transpose function is a built-in function in Excel, so you don’t need to write code or install add-ins.
How to use the Transpose in Excel Feature?
You can download this Transpose in Excel Template here – Transpose in Excel Template
To transpose data in Excel, there are 2 easy methods-
1. Using the TRANSPOSE Function in ExcelTo use the function Transpose in Excel worksheets, follow these steps:
Select a range of blank cells with the number of rows equal to the number of columns of the original array and the number of columns equal to the number of rows.
Enter the Transpose formula =TRANSPOSE(array).
With the range still selected, Press Ctrl + Shift + Enter.
Here is an example to demonstrate these steps in detail:
Step 2: Enter the formula below into cell G5 without pressing any keys.
=TRANSPOSE(A5:D11)
The Transpose in Excel function converts the vertical table into a horizontal table, i.e., the column headings are switched as row headings, and the column values are transferred to the rows.
Note: You must enter the TRANSPOSE formula as an array formula by pressing “Ctrl + Shift + Enter” instead of “Enter” to properly execute the function.
2. Using Copy-Paste FeatureTo use the Copy-Paste feature to Transpose in Excel, follow these steps:
Select the range of cells you want to transpose.
Choose “Paste Special” from the context menu.
In the Paste Special dialog box, check the Transpose” option.
Below is an example to demonstrate the above steps in detail:
Example #1A Paste Special dialog box appears.
The Vertical Table is converted into a Horizontal table, as shown below
The data in the column is shifted to rows
The column headings are transferred into row headings.
Example #2We cannot use the Copy-paste transpose feature if we want to change the source data. The changes will not reflect in the new table (array).
Things to RememberWhen using the Transpose function in Excel, several things must be remembered to ensure that the data transposes accurately and without errors. Here are some important things to remember:
The Transpose function must be used on a selection of the same size and shape as the original data. For example, if you have a table with three rows and four columns, the selection that one uses with the Transpose function must be four rows and three columns.
The data to be transposed must not contain any merged cells, as this can cause the function to fail or produce unexpected results.
The Transpose function can only be used on data not formatted as a table. To transpose a table, you must first convert it to a range.
It is essential to select the destination range carefully. If the destination range contains any existing data, it will be overwritten with the transposed data.
Final ThoughtsThe Transpose function in Excel is an essential tool for anyone who works with large datasets or wants to reformat data quickly and efficiently. By mastering the Transpose function, you can transform complex data sets into a more manageable and understandable format, making it easier to analyze, visualize, and make informed decisions based on the data.
Frequently Asked Questions (FAQs) Q1. Where is Transpose in Excel?Here are the steps to access the Transpose feature:
Select the cells that you want to transpose.
Choose “Paste Special” in the context menu or use the “Ctrl + Alt + V” shortcut.
In the Paste Special dialog box, check the “Transpose” option.
Note: Using the Transpose feature in the Paste Special dialog box will overwrite any currently in the cells where you paste the transposed data. Therefore, it’s a good idea to select an empty range of cells to paste the transposed data or create a new worksheet for the transposed data.
Q2. What is the importance of transposing data?Answer: Transposing data in Excel can be important for several reasons:
Changing the orientation: Transposing can help change the orientation of data from rows to columns or vice versa, making it easier to read or work with the data differently.
Analyzing data: Transposing can be useful when you want to analyze data in a specific way, such as comparing different data sets or performing calculations across multiple rows or columns.
Preparing data for charts or graphs: Certain types of charts or graphs require data to be in a specific orientation, and transposing can help you prepare the data accordingly.
Importing or exporting data: When importing or exporting data between different systems or applications, you may need to transpose the data to match the expected format or structure.
Q3. What does transposing data mean?Answer: Transposing an array or a dataset means swapping columns and rows so that the columns become rows and rows become columns.
For example, if you have a table of sales data where each row represents a different product and each column represents a different month, transposing the data would change the orientation so that each row represents a different month and each column represents a different product. This can be useful for certain calculations or for visualizing the data differently.
Q4. Is there a transpose formula in Excel?Answer: Yes. The Transpose formula is,
=TRANSPOSE(array)
For example, if you want to transpose the range A1:E4, you would enter the following formula in a cell where you want the transposed data to start:
=TRANSPOSE(A1:E4)
Once you have entered the formula, press Ctrl + Shift + Enter and the transposed data will be displayed.
Recommended ArticlesThis has been a guide to the TRANSPOSE Function. Here we discuss the TRANSPOSE Formula, how to use the TRANSPOSE Function, practical examples, and downloadable Excel templates. You can also go through our other suggested articles –
You're reading How To Quickly Transpose In Excel? Methods With Examples & Templates
Ipmt In Excel How To Use Ipmt Function In Excel? (With Examples)
IPMT Function in Excel
IPMT Function calculates a specific portion of interest based on the loan amount and tenure. The syntax of IPMT is quite similar to the syntax of PV Function in Excel, which all have seen earlier. To understand better, IPMT helps used to distinguish between different portions or segments of any loan and to what time how small amount is to be paid based on the interest applicable can be calculated.
IPMT Formula in Excel:
Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & others
Explanation of IPMT Function in ExcelThere are six parameters used for the IPMT function. Four parameters are compulsory, and two are optional.
Parameter details are as follows:
Compulsory Parameters:
Rate: The interest rate per period.
Per: The period for which you want to find the interest and must be in the range 1 to n per.
Nper: The total number of payment periods in an annuity.
Pv: The present value, or the lump-sum amount that a series of future payments is worth right now.
Optional Parameters:
[FV]: It is an optional argument. The FV or a cash balance you want to attain after the last payment is made. If FV is omitted, excel assumes it to be 0 (the future value of a loan, for example, is 0).
[Type]: This is also an optional argument. The number 0 or 1 indicates when payments are due. If this argument is omitted, Excel assumes it to be 0.
The Type can be 0 or 1, where:
1 = The payment is made at the start of the period.
How to Use the IPMT Function in Excel?IPMT function in Excel can be used as a worksheet function and a VBA Function. Here are some examples of the IPMT functions to understand the working of the IPMT function in Excel.
You can download this IPMT Function in Excel Template here – IPMT Function in Excel Template
Example #1Interest payment made for months 1 and 2 of a loan of $70,000, which is to be paid after 6 years. An interest rate of 6% per year, and the payment to the loan is to be made at the end of each month.
Result is :
To convert the annual interest rate of 6% into the monthly rate (=6%/12) and the number of periods from years to months (=6*12).
Example #2Interest during quarters 1 and 2 of an investment is required to increase investment from $0 to $6,000 over 3 years. The interest rate of 4.5% per year, and the payment into the investment is to be made at the beginning of each quarter.
Result is :
The annual interest rate has been converted into a quarterly rate (4.5%/4)
The number of periods has been converted from years to quarters (=3*4).
The [type]argument has been set to 1 to indicate that the payment will be made at the start of each quarter.
The interest for the first quarter is zero, as the first payment is made at the start of the quarter.
Note:
* Use N%/12 for rate and N*12 for nper when there are monthly payments. N%/4 for rate and N*4 for nper when quarterly payments and N% for rate and N for nper when there are annual payments.
*Cash paid out is shown as negative numbers. Cash received is shown as positive numbers.
Things to RememberBelow are a few error details that can come in the IPMT function as the wrong argument will be passed in the functions.
2. Error handling #VALUE!: IPMT function through a #VALUE! Error when any non-numeric.
VBA Function Example:
The IPMT function can also be used in VBA code.
For example:
Recommended ArticlesThis has been a guide to IPMT in Excel. Here we discuss the IPMT Formula in Excel and how to use the IPMT function in Excel, along with practical examples and downloadable Excel templates. You can also go through our other suggested articles –
Calculator (Examples With Excel Template)
Equity Formula (Table of Contents)
Start Your Free Investment Banking Course
Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others
What is Equity Formula?Equity = Total Assets – Total Liabilities
There is another method to derive the equity of a company. In this method, all the different classes of equity capital, which includes common/capital stock, share premium, preferred stock, retained earnings and accumulated other comprehensive income, are added while the treasury stocks are deducted. Mathematically, it is represented as,
Equity = Capital Stock + Share Premium + Preferred Stock + Retained Earnings + Accumulated Other Comprehensive Income – Treasury Stock
Examples of Equity Formula (With Excel Template)Let’s take an example to understand the calculation of Equity in a better manner.
You can download this Equity Formula Excel Template here – Equity Formula Excel Template
Equity Formula – Example #1Let us take the example of a company ABC Ltd that has recently published its annual report for the financial year ending on December 31, 2023. As per the balance sheet, the total assets of the company stood at $500,000, while its total liabilities stood at $300,000 as on December 31, 2023. Determine ABC Ltd’s equity as on the balance sheet date.
Solution:
Equity is calculated using the Formula given below.
Equity = Total Assets – Total Liabilities
Equity = $500,000 – $300,000
Equity = $200,000
Therefore, ABC Ltd’s equity stood at $200,000 as on December 31, 2023.
Equity Formula – Example #2Let us take the Real-Life example of Airbus SE’s published annual report as on December 31, 2023. As per the balance, the information is available. Calculate Airbus SE’s equity based on the given information.
Equity is calculated using the Formula given below.
Equity = Capital Stock + Share Premium + Retained Earnings + Accumulated Other Comprehensive Income – Treasury Stock
Equity = €777 + €2,941 + €5,923 + €134 – €51
Equity = €9,724 million
Therefore, Airbus SE’s equity stood at €9,724 million as of December 31, 2023.
ExplanationThe formula for equity can be derived by using the following steps:
Step 1: Firstly, determine the total assets of the company, which is the last line item on the asset side of the balance sheet and includes plant, machinery, cash, bank deposits, investments, etc.
Step 2: Next, determine the total liabilities of the company, which is also available in the balance sheet and includes all kinds of debt obligations, payables, etc.
Step 3: Finally, the formula for equity can be derived by subtracting the total liabilities (step 2) from the total assets (step 1) as shown below.
Under the other method, the formula for equity can be derived by using the following steps:
Step 1: Firstly, identify all the different categories of equity capital from the balance sheet.
Step 2: Finally, the formula for equity can be derived by adding up all the categories of equity capital except ones that have been repurchased and retired (also known as treasury stock) as shown below.
Equity = Capital stock + Share premium + Preferred stock + Retained earnings + Accumulated other comprehensive income – Treasury stock
Relevance and Uses of Equity FormulaFrom the perspective of an investor or an investment analyst, it is important to understand the concept of equity because it predominantly used to evaluate the real value of a company (net worth). In fact, the value of one’s equity investment in the company is captured by the equity value and as such the shareholders are typically concerned with the net worth of the company.
The value of equity can be both positive or negative. A positive equity value indicates that the company has adequate total assets to pay off its total liabilities. On the other hand, a negative value of equity indicates that the company may be on the way to become insolvent as the total liabilities exceed its total assets. Consequently, the investor community, in general, considers a company to be risky and perilous if it has a negative equity value. However, the value of equity in isolation may not give very meaningful insight into a company’s financial health. But an investor can use the equity value to analyze the company to draw significant conclusions if it is used in combination with other financial metrics.
Equity Formula CalculatorYou can use the following Equity Formula Calculator.
Total Assets Total Liabilities Equity Equity = Total Assets
–
Total Liabilities =
0
–
0
= 0
Recommended ArticlesThis is a guide to Equity Formula. Here we discuss how to calculate Equity along with practical examples. We also provide an Equity calculator with a downloadable excel template. You may also look at the following articles to learn more –
Linest In Excel (Formula, Examples)
LINEST in Excel
Linest function in excel is a statistical function used to calculate straight-line statistics and return an array from the available selected data, which also describes that line. In other words, the Linest function calculates the statistics of a simple line equation (Y = mx + C) which also explains the relationship between the dependent and independent variables using the least square procedure to find the best solution for the data used.
Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & others
LINEST Formula in ExcelBelow is the LINEST Formula in Excel :
LINEST Function in Excel includes the following parameters:
known_y’s: The known y’s is n range or array of y values from the line equation.
known_x’s: The known x’s is a range or array of x values from the line equation. If this x value is null, excel will assume those x_values as 1,2,3..with the same number of values as y values.
const: The const is a logical value that specifies either “TRUE” or “ FALSE”.
stats: The stat is a logical value that specifies either to return additional regression statistics, i.e. “TRUE” or “FALSE”, which function needs to return the statistics on the line of best fit.
Steps to Use the LINEST Function in Excel How to Use the LINEST Function in Excel?LINEST Function in Excel is very simple and easy to use. Let us understand the working of the LINEST Function in Excel by some LINEST Formula example.
You can download this LINEST?Function Excel Template here – LINEST?Function Excel Template
Example #1To use the LINEST as an array formula then, you need to do the following steps :
Select the cell where the function is and press f2.
Press CTRL +SHIFT +ENTER.
In this LINEST Function in Excel example, we will see how the LINEST function works with the data. Enter the data in Excel with two data captions named X and Y.
In order to use the LINEST function to find the exact result, Go to Formulas and choose the More function. Choose the LINEST Function under the statistical category, as shown below.
Choose the LINEST function, and you will get the below dialog box as shown below:
You will get the same value which is the coefficient m in the equation y=mx+b
So the result will be :
As mentioned above, we must press CTRL+SHIFT+ENTER to get the exact data. Now we can see that formula is enclosed with two parentheses, i.e. { } where the LINEST function is evaluated.
We can mention a straight line with slope and y-intercept. In order to get the intercept and slope regression, we can use the LINEST function lets see an example with step by step procedure.
Example #2In this example, we will see how to use the LINEST function in Excel. This function is used to calculate the line of Coefficient.
Line Equation: Y=mx+c
Using LINEST Function in Excel, we are going to calculate:
A line of Best Fit gradient
A line of best-fit intercept
The standard error of the gradient
The standard error of the intercept
R2
Regression Sum of squares
Residual sum of squares.
Consider the below data, which has X1 and Y1 values shown below:
To calculate the above equation, select the cell and insert the LINEST function shown below.
Use CTRL+SHIFT+ENTER to get all values where we can see the formula contains open and closing parenthesis.
Let’s see the same data how we can derive the same equation in a chart :
So that scatter chart graph will be displayed with the selected x and y data.
Now we will add a trend line to show exactly by selecting the scattered graph below.
Once you select the option “Add Trendline,” a new trend line will be added in the chart, as shown below.
It shows various statistical parameters like exponential, Liner, Logarithmic, and polynomial.
Here choose the polynomial option with an order 2, as shown below screenshot.
Scroll down and check to mark the display equation on the chart and display an R-Square value in the chart.
So the equation has been displayed in the chart as shown below with the same line equation.
Example #3 – LINEST Functioning for Multiple Range of X Values:Consider the below example, which has the same X1 and Y data and X2 values.
The following chart has been evaluated by using the scattered graph by adding a trend line function.
Assume the equation for Y=b+m1*X1+m2*X2
Lines Function : LINEST (Known_y’s,[Known_X’s],[const],[stats])
Consider the below array of a table which denotes as follows:
Where
m1 – denotes X
m2- denotes X2
Const- denotes b
LINEST Function Used in Earlier & Latest Versions:
In the earlier version, the LINEST function is used as a formula that is not correct to find the total sum of squares if the third argument to the LINEST function is set to false, and this causes an invalid value for the regression sum of squares. Also, values are incorrect for the other output sum of squares. The collinearity value caused a round of error, standard errors of regression coefficient that are not given exact results, and degrees of freedom that are not appropriate.
In Excel 2003 LINEST function has been improved and given good results by adding the TREND function to make it appropriate.
Things to Remember
The LINEST function in Excel should be used with appropriate values; if not, we will not get the exact result.
The LINEST function in Excel will not work If the array of Known_x’s is not as same as the array of Known_y’s.
Recommended ArticlesThis has been a guide to the LINEST in Excel. Here we discuss the LINEST Formula in Excel and How to use the LINEST Function in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –
Dcount In Excel (Formula, Examples)
DCOUNT Function in Excel (Table of Contents)
Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & others
DCOUNT in ExcelThe DCount function in Excel is a Database type function which is used to count the cell number, which contains only numbers or numerical values. The selected range for Database in the syntax can be a table or column. Fields part is optional, but here we can select the column whose value we need to count and then for Criteria part range those cell which has criteria. We need to mention the criteria in separate cells by which want cell count.
DCOUNT Formula in ExcelBelow is the DCOUNT Formula in Excel :
Below is the component of the DCOUNT function in Excel:
Database: The Range of cells that the user selected for applying criteria against. The field name must be there in the database. It is a mandatory field.
Field: The column name or the column number which tell excel which column in the database to count. It will be from the database only. It can be a field number / Index number. It can be omitted the result will be calculated on satisfying criteria.
Criteria: The range of cells which contain the conditions. The user specifies it. The criteria must contain at least one field name. Criteria can include multiple ranges as the condition specified by the user.
Note: The DCOUNT function is not case-sensitive. So, if the user provides data opposite case to the database, it will not affect the result of the function.
How to Use the DCOUNT Function in Excel?
You can download this DCOUNT Function Excel Template here – DCOUNT Function Excel Template
Example #1A user wants to calculate the total order made after Order id 11450 for Coke.
Pre-requisite: There is a list of order Id’s, Beverage Name and Expense on a beverage made by some customer. Criteria are written for the same on the top row for which the user wants to count total order.
Step 1: Select the G2 cell and write the DCOUNT formula =DCOUNT
Step 2: Select the database, which is first asked in function, so select B4 to D10.
Step 3: Now enter the field value or column name for which a user wants to count all cell.
Step 4: Enter the criteria for which the user wants to apply to the database.
Summary of Example #1:
A user can modify the criteria and can fetch data from the database according to his criteria given to the DCOUNT function in a fraction of seconds.
Example #2A user wants to calculate the total Product ID, which is Green in color and Price greater than 5 lakhs.
Pre-requisite: There is a list of Product Id, Color description, per item price, quantity and price tag on the product purchased by a customer. Criteria are written for the same on the top row for which the user wants to count total items.
Step 1: Select the I2 cell and write the DCOUNT formula =DCOUNT
Step 3: Now enter the field value or column name for which a user wants to count all cell.
Step 4: Enter the criteria for which the user wants to apply to the database.
Summary of Example #2:
A user can modify the criteria and can fetch data from the database according to his criteria given to the DCOUNT function in a fraction of seconds.
Example #3A user wants to calculate the total employee with a salary greater than 6 Lakhs and older than 30 years or whose name starts with the alphabet M and younger than 21 Year.
Pre-requisite: A user has data for some XYZ Company employee data, which have field name like First Name, age, salary and joining date.
Criteria are written for the same on the top row for which the user wants to count total items.
Step 2: Select the entire database, which is first asked in the DCOUNT function, so select B5 to E17.
Step 3: Now DCOUNT function will ask for a field name which we can omit, so a user can skip the field name value and just put a sing comma (,).
Step 4: Enter the criteria for which user wants to apply on the database, which written on top of the database.
Summary of Example #3:
The user wants to calculate the total employee with a salary greater than 6 Lakhs and older than 30 years or whose name starts with the alphabet M and younger than 21 Year. The same result is displaying in the resultant cell.
A user can modify the criteria and can fetch data from the database according to his criteria given to the DCOUNT function in a fraction of seconds.
A different way to use the DCOUNT function in Excel:
Field by Name: As we have used in the above example, we have given the field a name.
Field by Index: A user can give an index name or just a column number.
Field by Omitted: A user can omit the field value.
Things to Remember about DCOUNT Function in Excel
DCOUNT function in excel will count only if the user giving non-blank or numeric value. If the field value is blank or text value, then it will throw an Invalid Name Error.
Criteria can have multiple rows in the DCOUNT function in excel.
The database and criteria must have the same matching header; otherwise, it will not execute the function.
The field value can be Name in double quotes (” Name”) or field value index number.
If criteria in function left blank, then it will throw a #Value error.
The criteria can be put anywhere in the active sheet. Best to put on top of the database.
Always make sure the database and criteria or not overlap; there should be at least one-row gap in between.
Recommended ArticlesThis has been a guide to DCOUNT in Excel. Here we discuss the DCOUNT Formula in Excel and How to use the DCOUNT Function in Excel, along with practical examples and a downloadable excel template. You can also go through our other suggested articles –
Frequency In Excel (Formula, Examples)
FREQUENCY Function in Excel(Table of Contents)
FREQUENCY in ExcelThe frequency function in Excel is used to calculate how many times a number is getting repeated, in other words, we can say it calculates the occurrence of any number from the selected range of the bin table. If we see the syntax of the Frequency function, we will have a data array and bin array, whereas the data array is the complete range of data available, and the bin array is the number whose frequency we need to calculate.
Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & others
What is the FREQUENCY function in Excel?The FREQUENCY function returns how often values occur within a set of data. It returns a vertical array of numbers.
If you have age data for a group of children, you want to count how many children fall under different age ranges. Or you have the data of a school student and want to see how many students have achieved a grade of ‘A’, ‘B’, ‘C’ etc. For the above problems, we could use the FREQUENCY function in Excel.
FREQUENCY Formula in ExcelThe FREQUENCY Function has two arguments as below:
Data_array – An array or set of values for which you want to count frequencies.
Bins_array – An array of intervals (“bins”) for grouping values.
FREQUENCY counts how many times values occur in a dataset. This function has a special characteristic, and its usage differs from other formulas. While applying the FREQUENCY Function within a cell, type the formula and press CTRL+ SHIFT+ ENTER. This creates {} brackets around the formula, which Excel interprets as an array formula. If you simply press ENTER key, then this may return an incorrect result.
As FREQUENCY Function comes under the Statistical functions category, it is found under the FORMULAS tab. Please follow the below steps:
Select the More Functions option.
Please select the FREQUENCY Function from the drop-down listed item per the screenshot below.
Enter the Data_array, for which you want to count the frequencies.
Enter the Bin_array, for which you want to group the values in data_array.
How to Use FREQUENCY Function in Excel?The FREQUENCY Function in Excel is very simple and easy to use. Let us understand the working of the FREQUENCY Function in Excel by some FREQUENCY Formula examples.
You can download this FREQUENCY Function Excel Template here – FREQUENCY Function Excel Template
Example #1We have below some test scores:
According to the below intervals, we will apply the FREQUENCY formula.
The interval field is the second argument of the FREQUENCY Function Bins_array, which specifies the maximum values for the score ranges. This means the score is to be split into 0—60, 61-70, 71-80, 81-90 and 90+.
First, select the cells where we want to apply the FREQUENCY formula.
The Excel formula {=FREQUENCY(B4:B12, D4:D8)} into cells E4:E8 using CTRL+SHIFT+ENTER to complete the formula. This would give a vertical array with 5 values, as below screenshot:
The final result is shown below:
Explanation:
The first value will display in cell E4. The result would be 1 because only 1 test score <=60.
The second value is 3 because there are 3 test scores between 61 and 70.
The third value is 1 because there is only 1 test score between 71 and 80.
The Fourth value is 4 because there is 4 test score between 81 and 90.
Score 90+; there is no value.
Example #2We can apply the FREQUENCY Function to decimal values also. Let’s take an example of the heights of 11 children (in centimeters).
0.00-1.25 meter
1.26-2.75 meter
2.76-4.25 meter
4.26-5.75 meter
Over 5.76 meter
As shown in the above screenshot, the Formula used for the FREQUENCY distribution is:
{=FREQUENCY(A18:A28,B18:B21)}
The final result is :
Things to Remember
First, you need to highlight or select the range of cells for the result of applying an array formula.
Type the FREQUENCY Function into the first cell of the highlight range and press CTRL+SHIFT+ENTER.
FREQUENCY Function in Excel returns an array of values; it must be entered as an array formula.
Entering an array formula into too many cells can cause errors like #N/A. Only use the formula in the appropriate cells to avoid delays.
Recommended ArticlesThis has been a guide to FREQUENCY Function in Excel. Here we discuss the FREQUENCY Formula in Excel and how to use the FREQUENCY Function in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –
Update the detailed information about How To Quickly Transpose In Excel? Methods With Examples & Templates on the Daihoichemgio.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!