• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Matching lists

F

Flexorion

New Member
You guys were so helpful last time, I have another question!


I series of numbers that I need to synchronize with a chart, meaning I will have a master column with a series of several hundred serial numbers, and the incoming information will be four columns, one of which are the same serial numbers but in a random order. I need to put the information in all of the columns in the order of the master column. I'm having trouble figuring out how to do this one. Any ideas?
 
I'm assuming that all of the incoming numbers are found somewhere in the master list?


If so, create a helper column(s) with formula like:

=MATCH(NewNumber,MasterList,0)


Then, sort the incoming column and helper column by the helper column.
 
You must log in or register to reply here.
Back
Top