Off topic:How to arrange the second column according to the first column?
0
0
Entering edit mode
7.1 years ago
Grunir112 ▴ 10

I have two lists in Excel: List 1:

aa
33
2a
3de
432
s2e
3rr

List 2:

33
3de
432
s2e
2a
3rr
aa

(These are just an example. Actually, my list contains over 200 values per a column.) I want to arrange List 2 according to the List 1. In other words, I want List 2 to be exactly sorted as List 1 in Excel.

Can someone help me please? I have tried to use vlookup in Excel to arrange the two columns but it did not work.

Excel • 976 views
ADD COMMENT
This thread is not open. No new answers may be added
Traffic: 1488 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6