R
R
random_object2019-04-17 11:03:19
Search Engine Optimization
random_object, 2019-04-17 11:03:19

How to sort rows by value Excel?

Hello. There are 50k lines with the names of categories, products and service pages. Task. Sort only product pages that contain numbers from 1-9. How to do it?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Alexander Denisov, 2019-04-17
@random_object

5cb6e13669e9e938786684.png
Sort --> Between

K
keeplod, 2019-04-17
@keeplod

Highlight and press sort

J
John Smith, 2019-04-17
@ClearAirTurbulence

If they are out of sync with others, and not in a row, then there is no way through sorting.
First, select these lines, for example, with an autofilter, cut and move to the beginning / end - and then select them and sort them by sorting.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question