J
J
Jeff_Parker2022-02-09 13:48:30
Google Sheets
Jeff_Parker, 2022-02-09 13:48:30

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="По возрастанию";ИСТИНА;ЛОЖЬ))

62039b7e8a932946990294.jpeg

Link for tests

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2022-02-09
@Jeff_Parker

Piglets sent to school: #1 and #3. It took the school half a day to find the third one. Moral: how many columns in the original range of the example table are five? :-)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question