How to sort columns in relation to each other, and by keyword?

S

S

Shing2016-01-10 20:59:54

excel

Shing, 2016-01-10 20:59:54

How to sort columns in relation to each other, and by keyword?

How to sort columns in relation to each other, and by word within a sentence?
For example, there are columns
Vanya goes to school | She likes her school
Petya studies at her favorite academy | He loves to go to school
Valya visits his school | Academy near the house
Galya entered the academy | Not far from home academy
How can I make the values containing the keyword "academy" or "school" opposite each other, on the same line?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

P

Pavel2017-04-30 16:25:18

How to write an excel formula if there are a lot of "if"? 1Reply

V

Vasily Ivanov2019-10-03 21:56:49

How to convert XLS to XML with XSD Schema? 0Reply

I

Ilya2021-04-15 13:10:11

Calculated range in Google Sheets. How to wrap a formula? 1Reply

P

Pavel2021-04-16 13:00:52

How to enable full use of all cores in Excel? 2Reply

S

sound9012019-10-20 11:39:12

How to write a formula? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question