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

extracting data

Y

YVETTE

New Member
Hi,

I have a spreadsheet with 8 columns of one type of data- funder names. One of the columns (DRUM Funders) is my base, I want to extract from the other 7 columns the funder names that do not show up in my base column [DRUM Funders] and put these in a separate column. How do you do that? Spreadsheet attached.
 

Attachments

  • CrossRef_DRUM Funders.xls
    38.5 KB · Views: 0
Hi:
The easiest way is to copy all the funders into one column and use the remove duplicate wizard to remove the duplicates.

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