Answer the question
In order to leave comments, you need to log in
How to sort numbers?
There is a column with the number of reviews, but sorting - namely, the SORT function stubbornly does not want to sort the numbers in ascending or descending order, but calmly sorts by the first digit of the line in the cell. How can this be bypassed?
About the SORT function
https://support.google.com/docs/answer/3093150?hl=en
=SORT(A3:E413;ЕСЛИ(H1="Общему рейтингу";2;ЕСЛИ(H1="Кол-ву отзывов";3;ЕСЛИ(H1="Средней оценке последних";4;ЕСЛИ(H1="Средней оценке топовых";5))));ЕСЛИ(I1="По возрастанию";ИСТИНА;ЛОЖЬ))
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question