Learn how to sort data in a range or table in Excel 2013 with a few clicks. Watch the video and follow the steps to select, sort, and filter your data.B. Step-by-step demonstration of accessing the Sort function. Step 1: Open the Excel spreadsheet that contains the data you wish to sort. Step 2: Select the range of cells that you want to sort. This can be a single column, multiple columns, or an entire table. Step 3: Navigate to the Data tab on the Excel ribbon.The easiest way to sort in Excel is to use the Sort commands on the Data tab of the ribbon, in the Sort and Filter group. Here you'll find three basic options: two quick sort buttons—one for sorting in ascending order, and one for sorting in descending order—and a large button for custom sorting. We'll look at custom sorting in an upcoming ...Step 1: First, take your data set and insert a new row at the top of your data table. Number the new row according to the rearrangement recommendation. Step 2: Now select the cell where you want to rearrange your previous data table. In the formula bar, enter the following formula according to your data table position.One convenient sorting option many don't realize exists in Excel is list sorting. For instance, you may want to sort by day of the week or month of the year. Select your data and then "Sort" on the Data tab to open the Sort box. Choose the following in the drop-down boxes: 1. Sort by: Pick the column or row … See moreDec 18, 2022 · Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or d... Sort quickly. Select a single cell in the column you want to sort. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest). Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest). First, select any cell from the dataset. Next, select Sort & Filter >> Custom Sort or press Alt + D + S to open the Custom Sort. Here, we want to sort the sizes of the products first. Then each size will have the sales amount in ascending order. For that purpose, Select the column heading Size in the Sort by box.Step 1: Select the data first. Step 3: Under “Sort by, ” select “Region” name. Under “Order, ” select A to Z. Step 4: Click “Add Level” to add one more layer to the “Revenue” column. Step 5: Under this layer, select “Revenue” first and then “Largest to Smallest.”. Note: Firstly, Excel will sort region-wise data.22 Nov 2021 ... Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year.Step 1. Select the cells you'd like to sort. (Image credit: Excel) Step 2. Hover over the Data tab, and click Sort & Filter. (Image credit: Excel) Step 3. If you find your method of sorting in ...Below are the steps to unsort the data in Excel: Right-click on the left-most column. Click on the Insert column option. This will insert a blank column at the left of your dataset. [Optional] Add a header in cell A1. Add 1 in cell A2 and 2 in cell A3. Select both the cells (A2 and A3), place the cursor over the bottom-right part of the selection.Click anywhere in the data range, and in the Ribbon, go to Home > Sort & Filter > Custom Sort…. In the Sort window, choose any option under Column, choose Cell Color under Sort On, and select the first color (green for this example) under Order. Now click Add Level to add yellow and red with the same options as selected for green.1. Use Templates. You should not waste your time trying to recreate Excel spreadsheets from scratch every time you want to analyze your data. Instead, Microsoft Excel already includes a wide range of …Explore more Excel courses and advance your skills on LinkedIn Learning:h... Learn how to use the sorting tools in Microsoft Excel to organize your data better.6 Aug 2023 ... Sorting Data with Formulas · Select the range of cells you want to sort. · Go to the Data tab on the Excel ribbon. · In the Sort & Filter gr...Select your data Headers in Row 1 and the row to be sorted in row 2, A1:E2, open the Sort dialogue, and click on Options at the top of the dialogue box. In the Sort Options window that opens select "Sort left to right" and click OK. In the sort window choose Sort by Row 2 and choose the order of Largest to Smallest to have the row …Feb 7, 2024 · Add a Sort Button with a Keyboard Shortcut. The sort and filter toggles can also be added to your data selection with an easy shortcut combination. Select your data range and press the Ctrl + Shift + L keyboard shortcut to add the sort and filter toggles. This is an easy way to add or remove the filters as the shortcut acts as a toggle to turn ... Dec 18, 2022 · Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or d... Get FREE Advanced Excel Exercises with Solutions! Knowing how to sort range using VBA in Excel is time and effort-saving in our daily calculations. Although Excel provides a sorting facility by default. By using the Range.Sort method, we get access to several parameters to sort a dataset with more options than usual.First of all, right-click on the vertical axis of the bar chart and select Format Axis. Then, from the Axis Options, check the box of Categories in reverse order. Consequently, you will see that the bar chart is arranged in descending order. 4. Apply Formula to Sort Bar Chart in Descending Order in Excel.On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window. In the Sort by dropdown list, select the first column on which you want to sort. In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon. In the Order list, choose the order that you want to apply to the sort operation—alphabetically or ... 14 Oct 2021 ... The SORT function in Excel sorts the contents of a range or array. Example, =SORT(B2:B20). You can also sort in ascending or descending ...Feb 19, 2019 · Now navigate to the "Sort & Filter" drop-down and select the "Custom Sort" command. This brings up the Sort window. We will sort our data first by using the "Phase at STP" column so that all of the gasses will appear higher on the list than the solids. Select the "Phase at STP" column. Now press the "Add Level" button. Nov 18, 2019 · Select Sort & Filter to open the drop-down menu of sort options. Choose how you want to sort the data. Select either ascending or descending order. When using Sort & Filter, the sort order options in the drop-down list change depending upon the type of data in the selected range. For text data, the options are Sort A to Z and Sort Z to A. 24 Sept 2019 ... If you're wondering how to sort data alphabetically in Excel, you're in the right place! We'll be talking about a function which you can use ...Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions. You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. Excel will exclude that row from sorting. Select your column in the Sort by dropdown. Select the Cell Color in the Sort On dropdown. Select green in the Order dropdown and ensure On Top is selected so that green cells will appear first. Click Add Level and select your column again in the new Sort by dropdown. Select Cell Color …Method 1 - Using the A-Z icon. Using the data set below as a sample, we would probably want to alphabetize by last name using Column A. The absolute quickest way to alphabetize columns in Excel is to use the “A to Z” icon on the Data tab. Step 1 - Click on a cell in the column you want to sort by. Notice that A4 is our active cell in the ...Let’s sort our dataset based on alphabetical order for the Names. 📌 Steps. First, click on the dropdown menu beside the header “ Name ”. Then, click on the Sort A to Z It will sort the Name column in ascending order. Now, if you click on the Sort Z to A option, it will sort the dataset in descending order.Sort quickly. Select a single cell in the column you want to sort. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest). Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest). 28 Dec 2019 ... 2- Sort data by rows in Excel using the custom sort · Select the range without including the headers · Click “Sort” in “Data” tab, then “Options ...Sort quickly and easily. Select a single cell in the column you want to sort. On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest …Step-by-step guide on how to enable filtering in Excel. Step 1: Open your Excel spreadsheet and select the data range that you want to filter. Step 2: Click on the "Data" tab in the Excel ribbon at the top of the screen. Step 3: In the "Sort & Filter" group, click on the "Filter" button. This will add drop-down arrows to the header of each ...Learn how to sort data in a range or table in Excel 2013 with a few clicks. Watch the video and follow the steps to select, sort, and filter your data.B. Step-by-step demonstration of accessing the Sort function. Step 1: Open the Excel spreadsheet that contains the data you wish to sort. Step 2: Select the range of cells that you want to sort. This can be a single column, multiple columns, or an entire table. Step 3: Navigate to the Data tab on the Excel ribbon.If you don’t have a dishwasher, you’re missing out on one of the best time-saving appliances in the home. A dishwasher leaves your plates and cutlery with the sort of shine you can...Learn how to sort data in a range or table in Excel 2013 with a few clicks. Watch the video and follow the steps to select, sort, and filter your data.Provide step-by-step instructions on how to use the SUM function. To use the SUM function in Excel, follow these steps: Select the cell where you want the total to appear. Type =SUM (. Click and drag to select the range of cells you want to add up. Type ) and press Enter.Here’s a quick 3-step guide to sorting data in Excel using a keyboard shortcut: Select the range of data you want to sort. Hold down the “Alt” key and press “A,” “S,” and “S” in that order. Choose your sorting options and click “OK.”. Don’t forget – you can also use this shortcut to sort by multiple columns. Step 1: Select the Table or Range You Want to Clear Sort. The first step in clearing the sort in Excel is to select the table or range of cells that you wish to clear sort from. Click on any cell within the table or range and Excel will automatically select the entire block of data for you.B. Step-by-step demonstration of accessing the Sort function. Step 1: Open the Excel spreadsheet that contains the data you wish to sort. Step 2: Select the range of cells that you want to sort. This can be a single column, multiple columns, or an entire table. Step 3: Navigate to the Data tab on the Excel ribbon.Step 1: Select the row you want to sort. We will select the data range from C5 to Hence, from your Data tab, go to, Data → Sort & Filter → Sort. Since only one row has been selected from the table Excel will show you the Sort Warning dialog box. Select Expand the selection and click Sort.May 5, 2021 · 1. Select your data. You can either click and drag to select the column that you want to sort, or you can click one of the cells in the column to make it active and let Excel select the data automatically. 2. Click the Sort button. The Sort button can be found in the Data tab in the "Sort & Filter" section. Select Custom Sort. Select Add Level. For Column, select the column you want to Sort by from the drop-down, and then select the second column you Then by want to sort. For example, Sort by Department and Then by Status. For Sort On, select Values. For Order, select an option, like A to Z, Smallest to Largest, or Largest to Smallest.By default, the SORT function lists items in ascending order. To sort the same list in descending order, you would use the following formula which adds the order argument. =SORT(UNIQUE(A2:A10),,-1) Notice here we have a double comma again. This is because we don't want the index argument, only the order argument.Feb 7, 2024 · Add a Sort Button with a Keyboard Shortcut. The sort and filter toggles can also be added to your data selection with an easy shortcut combination. Select your data range and press the Ctrl + Shift + L keyboard shortcut to add the sort and filter toggles. This is an easy way to add or remove the filters as the shortcut acts as a toggle to turn ... 25 Sept 2013 ... What you can do is insert a blank row just above row 5 and another blank row just after row 15. This should create a separated "block". Then, ...Go to the Data tab > Sort and Filter group, and click Sort : In the Sort dialog box, click the Options... In the small Sort Options dialog that appears, select Sort left to …6 Aug 2023 ... Sorting Data with Formulas · Select the range of cells you want to sort. · Go to the Data tab on the Excel ribbon. · In the Sort & Filter gr...You can sort the dates either in ascending or descending order. First, select the data you want to sort and, then, select the option Sort & Filter. Choose Sort ...The syntax for the function is-. =RANK (number,ref, [order]) number- the number that we want to rank. ref- the set of numbers to rank against. [order]- the order is either ascending or descending. Task: We want to auto-sort the dataset according to its quantity ( column index = 2) in ascending order without macros.There are so many credit cards available today that it can be hard to sort through them all to find the one for your needs. If you are looking for a no annual fee credit card, one ...25 May 2021 ... How to Sort Multiple Criteria in the Single Column in Excel | Sort and Filter Functions in Excel 3 Hello and welcome back to Acadgild.22 Nov 2021 ... Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year.1. Reverse Order of Data Using Excel Sort Dialog Box. Here, we will use the Sort dialog box in Excel to reverse the order of data. It is available in the Data tab. The Sort dialog box is the most versatile technique for sorting your data because it allows you to select how you want the data arranged. In this method, we will use this tool both for the …The range, or array to sort [sort_index] Optional A number indicating the row or column to sort by [sort_order] Optional. A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order [by_col] Optional. A logical value indicating the desired sort direction; FALSE to sort by row (default), TRUE to sort by ... Learn how to sort your Excel data on one column or multiple columns in ascending or descending order. Follow the simple steps with screenshots and examples to sort records by Last Name or Sales.DATE. formula in place, select your "Month" or "Date" column and then click Home > Sort & Filter. From the drop-down menu, select either the "Sort Smallest To Largest" or "Sort Largest To Smallest" options. If you sort by smallest to largest, Excel will sort your data with the earliest year or month coming first.Enabling Sort & Filter for a Data Set. The first step to sorting and filtering data is enabling the capabilities of a dataset. Each of the steps needed to enable sort and filter in Excel is shown below: Step 1. Select the row of headers. Step 2. While on the "Home" tab, click the sort and filter button in the editing section of the ribbon. Step 3.To help prevent sorting problems, follow these steps before you sort Excel data: Select one cell in the column you want to sort. Press Ctrl + A, to select the entire region. Check the selected area, to make sure that all the data is included. For example, in the screen shot below, hidden column E is blank.Finding books at your local library is a helpful way to connect with the resources that you need for research or pleasure. Although sometimes it can be challenging to sort out whic...Select Custom Sort. Select Add Level. For Column, select the column you want to Sort by from the drop-down, and then select the second column you Then by want to sort. For example, Sort by Department and Then by Status. For Sort On, select Values. For Order, select an option, like A to Z, Smallest to Largest, or Largest to Smallest.In this section, we will sort the last names using the Text to Columns method. Follow the steps below to perform the task. First, select Data and press the Text to Columns option in the Data Tools group. As a result, you will see the Convert Text to Column Wizard dialogue appear. Here, select Delimited and click Next.Learn how to sort a range or table of data on one or more columns of data in Excel, using the Data tab's Sort & Filter group. You can also sort by specifying criteria, such as font or cell color, and choose the order of the sort operation. 24 Sept 2019 ... If you're wondering how to sort data alphabetically in Excel, you're in the right place! We'll be talking about a function which you can use ...To do this, go to the ‘Data’ tab, and choose ‘Sort & Filter > Clear’. This method removes all sorting from your worksheet and restores the original order of your data. It is important to note that clearing all sorts in Excel does not delete any data from your worksheet.Formulas and functions are both important tools when creating an Excel spreadsheet; while users type formulas right into the bar at the top of the spreadsheet, formulas come built ...Introduction Sorting data in Excel for Mac is a crucial skill for anyone working with spreadsheets. Sorting allows you to organize and analyze data effectively, making it easier to identify trends, patterns, and discrepancies. Knowing how to sort in Excel for Mac can save you time and effort, as well as improve the accTo sort a list randomly in Excel, first you need to add a new column to your data. When using Excel Tables, you can simply type in a new column name at the next available table header and it will be automatically joined to your table. Here, we type in “Sort Order” and press Enter. Next, we need a way to randomly sort the list.Select the entire data range (B1:B9), and in the Ribbon, go to Data > Sort. In the Sort window, (1) select Order for Sort by, (2) Largest to Smallest for Order, and (3) click OK. As a result, the data range is sorted in a descending order by Column C, which means that names in Column B are now in the reverse order.Add a Sort Button with a Keyboard Shortcut. The sort and filter toggles can also be added to your data selection with an easy shortcut combination. Select your data range and press the Ctrl + Shift + L keyboard shortcut to add the sort and filter toggles. This is an easy way to add or remove the filters as the shortcut acts as a toggle to turn ...Learn how to sort a range or table of data on one or more columns of data in Excel, using the Data tab's Sort & Filter group. You can also sort by specifying criteria, such as font or cell color, and choose the order of the sort operation. Begin by selecting the range of cells. In this example, it’s A1:C15. Under Data on the ribbon, click the Sort command. The Sort dialogue box will pop up and it allows you to sort by column, sort on criteria, and order. In our case, it’s to sort the zip column, based on the cell values, from smallest to largest. Steps to Sort Dates by Month. First, in the second column (Column B) create a heading with the name “Month”. In cell B2, enter the Month function and refer to cell A2, where you have the data. Once you enter, hit enter to get the result. After that, drag down the formula up to the last cell of the column.Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions. You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. Dec 21, 2023 · STEPS: First of all, select the range and go to Data Sort & Filte r Sort. As a result, the Sort dialog box will pop out. Here, press Options. Afterward, select the circle for Sort left to right and press OK. Then, select Row 4 ( Headers row) and select A to Z in Order. Subsequently, press OK.
Learn how to sort your Excel data on one column or multiple columns in ascending or descending order. Follow the simple steps with screenshots and examples to sort records by Last Name or Sales.. Adam kotas
7 Sept 2021 ... penggunaan Excel pun mudah, karena fitur didalamnya seperti bisa melakukan perhitungan sederhana, mengurutkan data, hingga kamu bisa ...2 Jul 2019 ... In this video, learn how to sort data from left to right in Excel. Mostly we get datasets that are arranged in columns (with headers in a ...Nov 17, 2021 · To get started, open your spreadsheet with Microsoft Excel. In the spreadsheet, click the header of the column in which you want to alphabetize data. In Excel's ribbon at the top, click the "Data" tab. In the "Data" tab, under the "Sort & Filter" section, you will find options to alphabetize your data. To sort your data A to Z, click the "AZ" icon. 6 Aug 2023 ... Sorting Data with Formulas · Select the range of cells you want to sort. · Go to the Data tab on the Excel ribbon. · In the Sort & Filter gr...Learn how to sort data by text, numbers, dates, colors, icons, or custom lists in Excel. Find out how to use AutoFilter, conditional formatting, and functions to sort by top or bottom values or partial values.Learn how to sort a range or table of data on one or more columns of data in Excel, using the Data tab's Sort & Filter group. You can also sort by specifying criteria, such as …To order the months in chronological order, highlight the cells in the range A1:B13, then click the Data tab along the top ribbon, then click the Sort button. In the new window that appears, click the Add Level button in the top left corner, then under Column choose Month and under Order choose Custom List: In the new window that appears, …Nov 18, 2019 · Select Sort & Filter to open the drop-down menu of sort options. Choose how you want to sort the data. Select either ascending or descending order. When using Sort & Filter, the sort order options in the drop-down list change depending upon the type of data in the selected range. For text data, the options are Sort A to Z and Sort Z to A. Apr 27, 2023 · Select your data Headers in Row 1 and the row to be sorted in row 2, A1:E2, open the Sort dialogue, and click on Options at the top of the dialogue box. In the Sort Options window that opens select "Sort left to right" and click OK. In the sort window choose Sort by Row 2 and choose the order of Largest to Smallest to have the row sorted in ... Select Custom Sort. Select Add Level. For Column, select the column you want to Sort by from the drop-down, and then select the second column you Then by want to sort. For example, Sort by Department and Then by Status. For Sort On, select Values. For Order, select an option, like A to Z, Smallest to Largest, or Largest to Smallest. Feb 23, 2023 · Select the dataset > Click on the Sort option in the Data tab. Choose the Area column to sort. Select Cell Values under Sort On. Under Order, choose A-Z. Select Add Level, and choose the Agent column. Now sort on Cell Values and Order it by Z-A. Fig: Sorting based on Area and Agent columns. The next topic in this article on how to sort data in ... Formulas and functions are both important tools when creating an Excel spreadsheet; while users type formulas right into the bar at the top of the spreadsheet, formulas come built ...Custom sort in Excel with a formula. To sort data in a custom order, you can either use Excel's Custom Sort feature or build a SORTBY MATCH formula in this way: SORTBY (array, MATCH ( range_to_sort, custom_list, 0)) Taking a closer look at our data set, you will probably find it more convenient to sort the projects by their status "logically ...Nov 17, 2021 · To get started, open your spreadsheet with Microsoft Excel. In the spreadsheet, click the header of the column in which you want to alphabetize data. In Excel's ribbon at the top, click the "Data" tab. In the "Data" tab, under the "Sort & Filter" section, you will find options to alphabetize your data. To sort your data A to Z, click the "AZ" icon. Mar 14, 2023 · The SORT function in Excel sorts the contents of an array or range by columns or rows, in ascending or descending order. SORT belongs to the group of Dynamic array functions. The result is a dynamic array that automatically spills to neighboring cells vertically or horizontally, depending on the shape of the source array. .
Popular Topics
Spider man across the spider verse soundtrack | Mar 17, 2023 · Go to the Data tab > Sort and Filter group, and click Sort : In the Sort dialog box, click the Options... In the small Sort Options dialog that appears, select Sort left to right, and click OK to get back to the Sort. From the Sort by drop-down list, select the row number you want to alphabetize (Row 1 in this example). 3. Use the third argument of the SORT function to sort in a different order. The SORT function below sorts by the first column, in descending order. Note: use 1 to sort in ascending order, use -1 to sort in descending …...
Pollo al carbon | If you want to both sort and filter your data with a single formula in Microsoft Excel, you can do this by combining the SORT function with the FILTER function. In this article I will show you multiple ways of combining these two formulas so that you can sort and filter with a single formula, as well as have the ability to sort and filter by multiple conditions, in a …Select your data Headers in Row 1 and the row to be sorted in row 2, A1:E2, open the Sort dialogue, and click on Options at the top of the dialogue box. In the Sort Options window that opens select "Sort left to right" and click OK. In the sort window choose Sort by Row 2 and choose the order of Largest to Smallest to have the row …In this tutorial we take a closer look at the sorting options in Excel. You'll learn how to do more complex sorting, including multi-level sorting. #excel #......
Simplify fractions | Add a Sort Button with a Keyboard Shortcut. The sort and filter toggles can also be added to your data selection with an easy shortcut combination. Select your data range and press the Ctrl + Shift + L keyboard shortcut to add the sort and filter toggles. This is an easy way to add or remove the filters as the shortcut acts as a toggle to turn ...Sort quickly. Select a single cell in the column you want to sort. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest). Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest). Sort the Pokemons in the range A2:A21 by their Name, ascending from smallest to largest (A-Z). Select A2:A21. Open the Sort & Filter menu. Click Sort Ascending. Note: A1 is not included as it is the header for the column. This is the row that is dedicated to the filter. Including it will blend it with the rest. Copy Values....
Snoop dogg and martha stewart | From the top of the page, click "Data" to switch tabs. Locate "Sort & Filter," then click the "Filter" icon. This will add a small down arrow to the right of each heading. Click the arrow next to "Total $" and sort by largest to smallest or smallest to largest by clicking the appropriate option in the dropdown.Step 1: Select the range of data that you want to sort. Step 2: Click on the "Data" tab in the Excel toolbar. Step 3: Click on the "Filter" button to add filter drop-downs to each column header. Step 4: Use the filter drop-downs to select the blanks in the column that you want to remove the blank rows from. Check if the Ribbon has the Automate Menu, if not, you have to enable this from File, options, Custumize Ribbon, and add the Automate Tab to the right side, click on OK. 3. Select Automate Tab and Click New Script. 4. On the Right side of excel wil will have this Window. Erase the existing code and paste this one....
The sound of silence lyrics | Nov 9, 2022 · To use the Excel SORT function, insert the following formula into a cell: SORT (range, index, order, by_column). The SORT function will sort your data without disturbing the original data set. While Microsoft Excel offers a built-in tool for sorting your data, you may prefer the flexibility of a function and formula. Formulas and functions are both important tools when creating an Excel spreadsheet; while users type formulas right into the bar at the top of the spreadsheet, formulas come built ...Explore Copilot in Excel and find out how Copilot can assist with data analysis, comprehension, and visualization using the power of AI. Go deeper with data Use Copilot to help you explore and understand your data better. Have access to Copilot?...
Cleopatra parents | Open the Sort Dialog Box: Go to the Data tab and click on the Sort button. Choose the Sorting Options: In the Sort dialog box, select the column you want to sort by from the Sort by dropdown menu. Select the Order: Choose the desired sorting order, such as A to Z or Z to A, from the Order dropdown menu. Apply the Sort: Click OK to apply the ...Custom sort in Excel with a formula. To sort data in a custom order, you can either use Excel's Custom Sort feature or build a SORTBY MATCH formula in this way: SORTBY (array, MATCH ( range_to_sort, custom_list, 0)) Taking a closer look at our data set, you will probably find it more convenient to sort the projects by their status "logically ......