Yes! When using the auto serial numbers, the issue with filtering/sorting is there.
![ascending number fill exce ascending number fill exce](https://i.pinimg.com/736x/61/a9/46/61a946edad277daa6a0a5d7604ff34cd.jpg)
We did it by using the IF logical function in Google sheets here.
![ascending number fill exce ascending number fill exce](https://hi-static.z-dn.net/files/d09/ea10beee54fcc95cbddc095395859a6e.jpg)
The row number function applied in Cell A3 is ROW(A3). Now back to our topic.Īs per the example (refer to screenshot above) our row numbering to be started from row number 3.
![ascending number fill exce ascending number fill exce](https://www.excelhow.net/wp-content/uploads/2020/09/7.png)
This formula will return the row number of the formula applied cell. This function can return the row number of a specified cell. To return the 2nd and 3rd largest quantity, copy the same formula by pressing the key “CTRL+C” and select the range E3:E4 and paste by pressing the key “CTRL+V” on the keyboard.Here I’ve used the ROW function.The function will return the first largest sold quantity.Select the cell E2 and write the formula.To sort the data in descending order through formula follow the below mentioned steps:. How arrange the data in descending order through formula? To return the 2nd and 3rd smallest quantity, copy the same formula by pressing the key “CTRL+C” and select the range D3:D4 and paste by pressing the key “CTRL+V” on the keyboard.The function will return the first smallest sold quantity.Select the cell D2 and write the formula.To sort the data in ascending order through formula follow the below mentioned steps:. How arrange the data in ascending order through formula?
![ascending number fill exce ascending number fill exce](https://www.exceldemy.com/wp-content/uploads/2021/07/Single-Column-Numerical-Value-Sort-by-SMALL-1536x967.png)
In column D we need to return the 3 Smallest sold quantity and in column E we need to return the 3 largest sold quantity. To understand how you can sort numbers in ascending or descending order, let’s take an example.Įxample 1: We have a list of fruitsalong with the sold quantity Column “A” contains the names of the fruits and column “B” the sold quantity. And to sort in descending order use the “LARGE” function along with the “ROW” function. To sort in ascending order use the “SMALL” function along with the “ROW” function. To sort the numbers in ascending or descending order, we use the formulas “LARGE”, “SMALL” and “ROW” in Microsoft Excel.