Is there a way to search and sort the same string?

Number in order in column A.There is input from Hokkaido to Okinawa in column B.(in the order shown in the statistical survey in general)
A state ranking (with numbers) of an item is entered in column C.

ABC

1 Hokkaido Miyazaki Prefecture (63.4)
2 Aomori prefecture... (62.2)
~ ~
47 Okinawa prefecture...(45.2)

How do I sort column C in the same way as column B using a function?
If there is a simple way, please let me know.

excel

2023-01-17 23:06

1 Answers

First, we divide column C into two columns, divided into prefecture names and numbers.After that, you can use the state name in column B to VLOOKUP.

2023-01-17 23:14

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656