To sort duplicates in rows using the SORTBY function: Replace the cell ranges accordingly with your cell range and insert 1 for ascending order or -1 for descending order. After that, the quantities get sorted for the respective items. The formula sorts based on items at first, as B7:B23 is put before C7:C23. 1 implies ascending order, so we’ll sort the range in ascending order. Here, B7:B23 (Items) and C7:C23 (Quantity) are the cell ranges based on which we’ll sort the cell range B7:C23. To sort duplicates in columns using the SORTBY function: Here are the 2 cases of using the SORTBY function to sort duplicates: Case 1: Sorting Duplicates in Column The SORTBY function sorts a range or array of data based on the values in another range or array. Read More: How to Arrange Numbers in Ascending Order in Excel Using Formula Using SORTBY Function
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |