EXCEL FORMULA FOR MULTIPLE ROWS HOW TO

Select the data range that we want to sort (B3:G4), and in the Ribbon, go to Home > Sort & Filter > Custom Sort.Ģ. In order to achieve this, follow the next steps.ġ. In this case, we will first sort by MTD Sales, and then by YTD Sales, from largest to smallest. To be able to sort equal values for MTD Sales, we will add one more level of sorting – YTD Sales (row 4). In order to add additional sort criteria, we can sort multiple rows horizontally. In the sorted data, we have two times the equal amounts – for John and Celine ($1,280) and for Jennifer and Sarah ($750). In the Sort window, (1) choose Row 3 for Sort by, (2) Largest to Smallest for Order, and (3) click OK.Īs a result, our data set is sorted by row 3 (MTD Sales) descending. This option stands for horizontal sort, while top to bottom means vertical sort.Ĥ. In the Options pop-up, select Sort left to right, and click OK. Click anywhere in the data range that we want to sort (A3:G3), and in the Ribbon, go to Home > Sort & Filter > Custom Sort.ģ. Let’s first sort data horizontally by MTD Sales from largest to smallest (row 3). Also, in row 4, we have year-to-date sales. In row 2, there are Names, while in row 3, there are month-to-date sales for every person from row 2. Instead of usual column data storing, in this example, we have rows-oriented data. Let’s say that we have the following data set. In Excel, we can use the sort option to sort rows horizontally.

EXCEL FORMULA FOR MULTIPLE ROWS HOW TO

In this tutorial, you will learn how to sort multiple rows horizontally in Excel and Google Sheets.

Excel formula for multiple rows