• 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.

Need help getting numbers in cell to match with numbers in another cell

S

SgtSpeccy

New Member
Hi All

Please see attached files. I need kcode1 to end up looking like kcode2. Reason being is, there is just under 5500 different numbers in the first column spread over 275000 plus rows.

I hope somebody can help.

Ian
 

Attachments

  • kcode1.xlsx
    8.7 KB · Views: 2
  • kcode2.xlsx
    8.7 KB · Views: 2
First remove duplicates from column A. & paste the same in column C In column D Use the index formula & in later cells concatenate. Attached the file with the formula.
 

Attachments

  • kcode1.xlsx
    10 KB · Views: 4
vletm said:
Press 'Do Kodes'-button on Sheet1, check file
Click to expand...
Thank You to yourself and srinidhi for coming back to me. Somebody came back to me on a different forum with the same example but with out the rather helpful do kodes button.

Once again, thank you for your help.

Ian
 
You must log in or register to reply here.
Back
Top