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

Search results

  1. S

    Creating a unique column from a column of duplicates

    if i understand correctly, you have two problems: 1) getting rid of the entries in col B wchihc are "na" 2) getting rid of duplicates from the remaining data set the quick and dirty way is 1) to do autofilter. go to col b, click the dropdown for custom and choose not equal na.copy the...
Back
Top