Question

Excel spreadsheet automatically

Answer 1

How to sort automatically in Excel
1st step:
2nd step:
3rd step:

---

You can have the data in your Excel table sorted automatically. We'll explain how it's done..

If you want to list data or results sorted in your Excel spreadsheet, you do not need to clean up manually. Excel sorts your table automatically with a formula. We explain exactly how this works in our instructions.

Tip : You can read here how to sort alphabetically in Excel quickly and easily.

How to sort automatically in Excel

1st step:

To automatically sort with a formula, you can use the formula = SMALLEST (range; k) . So select a cell in a column where you want the sorted values ​​to be, and then enter the formula. For the range, enter the cells whose values ​​you want to sort. In our example these are cells B2 to B10. Then enter a k . This parameter defines how much the smallest value you want to display. If you enter 2 here, for example, the second smallest value is output, for 3 the third smallest value is output, etc. To sort the values, however, it is advisable to select 1 for k first.

2nd step:

Now go down one cell and enter the formula again, but instead of 1 for k, choose 2 . One cell below, enter the formula again and then select 3 for k accordingly . After that, keep going down and adjusting your k in the formula until you get to the last cell of your range.

3rd step:

Your values ​​should now appear sorted in the column, even after you change values ​​in the range you specified. If you would prefer to sort in descending order instead , you can use the formula LARGEST instead of SMALLEST .

---