Ask Your Question

HELP sort a column based on data in another column

asked 2018-11-23 11:21:16 +0100

SHano gravatar image

updated 2018-11-23 12:57:15 +0100

image description

In the Above worksheet I have two columns, Column A Data has a matching row that contains the text in Column B eg. 2017_PS_DE_Epay_gCard_WEWCY_VD_BAR.eps from Column A and WEWCY from Column B

I am looking to re sort Column A into a new column so the rows match the corresponding Data in Column B

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-17 16:38:15 +0100

LeroyG gravatar image

Paste in C1: =VLOOKUP("*"&SUBSTITUTE(MID(B1;FIND(" ";B1);99);"x.x";"")&"*";A:A;1;0)

Drag C1 down into all occupied rows, then choose menu Data - Text to columns…, unmarck checkboxes, OK. Check results for possible errors.

Formula adapted from @m.a.riosv at An ad hoc answer is welcome, then I delete mine; I'll upvote.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-23 11:21:16 +0100

Seen: 102 times

Last updated: Jul 17