SORT Function Archives

4 Ways to Remove Duplicates from Drop-Down List in Excel

April 9, 2023

Duplicate Values appear often in our workbook. If we want to make drop-down list based on a column that contains duplicates, all the values will ...

5 Easy Ways to Highlight Highest Value in Excel

March 29, 2023

Are you a teacher? Do you need to find the students who scored the highest in the final exam? Perhaps you are an entrepreneur looking for an easier ...

6 Easy Ways to Highlight Lowest Value in Excel

March 27, 2023

Are you a teacher? Do you need to find the students who scored the lowest in the final exam? Perhaps you are an entrepreneur looking for an easier ...

5 Ways to Copy Unique Values to Another Worksheet in Excel

March 22, 2023

Sometimes we get datasheets with many duplicate values and we have to extract the unique values removing the duplicates. In this article, we will ...

5 Ways to Create a Top 10 List with Duplicates in Excel

April 2, 2023

If you are a teacher, you might want to list the top 10 students who scored highest at the end of an academic year. Or maybe you are an entrepreneur ...

8 Ways to Create a Unique List Based on Criteria in Excel

December 10, 2022

Maybe you have a list of repeating data that you want to sort. In Excel, you can actually make a unique list based on criteria. However, this is only ...

8 Ways to Arrange Numbers in Ascending Order in Excel Using Formula

March 20, 2023

We can use Microsoft Excel for arranging numbers in ascending or descending order by using SORT from the toolbar or just creating a table and then ...