SORT Function

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

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

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

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

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

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

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

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 ...

5 Ways to Auto Sort When Data Is Entered in Excel

Sometimes we need to auto-sort when data is entered in Excel. In this article, we are going to show you how to auto-sort when data is entered in ...

6 Ways to Auto Sort When Data Changes in Excel

Sorting from data congestion is a real challenge nowadays. In real life, there is a lot of data. Auto Sort When Data Changes in Excel is ...

How to Extract Unique Values Based on Criteria in Excel

We live in an age of information revolution. Lots of data is taking place every day. The greatest challenge is to extract particular data for ...