Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Find Multiple Values in Excel (With Example)
You can use the following formula to find multiple values in Excel:
=INDEX($A$1:$B$12,SMALL(IF($A$1:$A$12=$F$1,ROW($A$1:$A$12)),ROW(1:1)),2)
This particular formula finds all of the values in the range B1:B12 where...
Descriptive Statistics in Excel
Excel: How to Remove Grand Total from Pivot Table
Often you may want to remove the grand total row from a pivot table in Excel.
Fortunately this is easy to do by using the...
Descriptive Statistics in Excel
How to Count Unique Values by Group in Excel
You can use the following formula to count the number of unique values by group in Excel:
=SUMPRODUCT(($A$2:$A$13=A2)/COUNTIFS($B$2:$B$13, $B$2:$B$13, $A$2:$A$13, $A$2:$A$13))
This formula assumes that the...
Descriptive Statistics in Excel
Excel: How to Create Pivot Table from Multiple Sheets
The following step-by-step example shows how to create a pivot table from multiple sheets in Excel
Step 1: Enter the Data
Suppose we have a spreadsheet...
Descriptive Statistics in Excel
How to Group Data by Week in Excel
Often you may want to group data by week in Excel.
Fortunately this is easy to do using the WEEKNUM() function.
The following step-by-step example shows...
Descriptive Statistics in Excel
How to Count by Month in Excel
You can use the following formula to count the number of occurrences by month in an Excel spreadsheet:
=SUMPRODUCT(1*(MONTH(A1:A10)=11))
This particular formula counts the number of...
Descriptive Statistics in Excel
Excel Pivot Table: Calculate Sum & Count of Same Field
Often you may want to calculate the sum and the count of the same field in a pivot table in Excel.
You can easily do...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read