excel - Sort a list by another list... to organize matching pairs on the same row -
i know title sounds little funky. i'm trying do: have large list of data , i'm trying sort small list off of large list. want small list row number match large list row number. looks this:
aaa aaa bbb ddd ccc eee ddd hhh eee kkk fff ggg hhh iii jjj kkk
what want this:
aaa aaa bbb ccc ddd ddd eee eee fff ggg hhh hhh iii jjj kkk kkk
i didn't see in research, wondering if there's simple way in excel. tried pivot table couldn't results want.
insert column between with:
=iferror(if(match(a1,c:c,0)>0,a1,),"")
copied down, select first 2 columns, copy, paste special, values... on top , delete third column.
Comments
Post a Comment