how to sort data by color in excel for mac 2016

In our example, we’ll select SUM to find out the total number of T-shirts lying in each warehouse. We need to choose depending on our requirements. Next, we need to click the drop-down arrow for the “Use function: field.” This will help us select the function we wish to use. Now, click the drop-down arrow for the “At each change in: field.” We can now select the column we wish to subtotal. When we click on it, the Subtotal dialogue box will appear as shown below: Select the Data tab, and click on SUBTOTAL. The next step would be to apply the SUBTOTAL function. To do that, we can use the SORT function under the Data tab. As we need to get the subtotals of T-shirts by colors, we will sort it accordingly. Step 1įirst, we need to sort the worksheet on the basis of data we need to subtotal. Now for the analysis, we need to get the total number of T-shirts of each color lying in the warehouse. The warehouse manager provides random data. He produces these T-shirts in seven different sizes, i.e. He manufactures T-shirts of five different colors, i.e., White, Black, Pink, Green, and Beige. We use data provided by a garment manufacturer. Let’s understand this Excel function with the help of an example. Formatting and sorting of the provided Excel data.There are two steps to follow when we wish to use the SUBTOTAL function. To learn more, launch our free Excel crash course now! How to use the SUBTOTAL Function in Excel? The SUBTOTAL function will help you to get a count of different sizes in your warehouse. SUBTOTALS help us to get the totals of several columns of data broken down into various categories.įor example, let’s consider garment products of different sizes manufactured. Sometimes, we need data based on different categories.

Range1,range2…range_n is the range of cells you wish to subtotal Why do we need to use SUBTOTALS? Where method is the type of subtotal you wish to obtain

Thus, the SUBTOTAL function in Excel helps in analyzing the data provided. The SUBTOTAL Function in Excel allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Updated OctoWhat is the SUBTOTAL Function in Excel?

How to sort data by color in excel for mac 2016