Question

Excel: Use PARTIAL RESULT function

Answer 1

How to apply PARTIAL RESULT
1st step:
2nd step:
3rd step:
4th step:
5th step:
6th step:
quick start Guide

---

You can group your sorted Excel table with the partial result function. You can find out how to use the function here..

Excel's subtotals function is an extremely useful tool. With this you can, among other things, add up values ​​sorted according to characteristics or calculate the mean value. At the same time, your table is structured and grouped in order to hide individual levels so that only partial results can be displayed. This may sound complicated, but it is not at all. With our help, you too can easily use the partial result function.

Look here for more tips on controls and formulas in Excel.

How to apply PARTIAL RESULT

Follow our step-by-step instructions or take a look at the brief instructions ..

1st step:

First you need to sort your list. To do this, right-click on any cell in the table column by whose category you want to sort, and select " Sort " and " Sort from A to Z " from the list .

2nd step:

After sorting, select any cell in the table again and switch to the " Data " category at the top . Under " Outline " click on " Partial result ".

3rd step:

In the new window you can now make some settings for calculating the partial result. As a rule, Excel sets this correctly. It starts with " Group by ", the field by which you want to group or for which you want to calculate your partial results . In our example this is "continent" because we want a partial result after each continent. For " Using " we leave " Sum " in place. There you can also enter the minimum or maximum, for example to adjust. The sums are calculated from the "Inhabitants" column, so we put a check mark in front of it. Finally, leave the checkmarks for " Replace existing partial results " and " Show results below the data " and click on the " OK " button .

4th step:

Your table should then look like the one shown above. In order to nest partial results, i.e. to display several partial results in a table, open the " partial results " window again as just before .

5th step:

There you now select another value under " Group by ", for which the partial result should also be displayed, in our example "Country". Remove Now check " Replace existing partial results " in order to keep the just calculated partial results. Confirm again with " OK "

6th step:

Your table should now look like the one shown above.

quick start Guide

1. First, sort your list by right-clicking on a cell in the column whose category you want to sort by. Then select " Sort " and " Sort from A to Z ".
2. Then select any cell in your table, switch to the " Data " category at the top and click on " Subtotal " under " Outline ".
3. In the new window you can adjust the parameters for your partial results. With " Group by " select the category for which the partial results are to be created. " Using " decides what you charge. You can also select other settings here, such as the minimum or maximum . Check the value of the column from which the result is to be calculated. Leave the checkmarks for " Replace existing partial results " and " Show results below the data " and click on " OK ".
4. In order to nest partial results, i.e. to generate several partial results in a table, open the " partial results " window again .
5. In " Group by " select a different value and remove the checkmark for " Replace existing partial results " so that the partial results that have just been calculated are not lost. Click OK .
6. You should now see partial results for two categories.

---