×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Unifying two lists with different lengths

Unifying two lists with different lengths

Unifying two lists with different lengths

(OP)
Hello everyone,
I would appreciate your help.
I have two specimen lists, with different lengths, and I wish to unify them (it is difficult to explain, so I attached an Excel file to show what I mean).
Many thanks in advance!
BrCo

RE: Unifying two lists with different lengths

Yes I'm afraid the worksheet is equally unclear as your posting.

RE: Unifying two lists with different lengths

(OP)
Sorry about that, I'll try to explain myself better.
I am doing a survey, counting how many specimens of each species are living in each sub-sample. There are 2 lists: the overall list (rows 3 and 4), and the sub-sample list (rows 6 and 7). The overall list includes all the potential species, but the sub-sample list does not necessarily include all of them (that is, some species are not present in the sub-sample). What I want is to put each specimen count of the sub-sample (row 7) in its proper place in row 4. For example, the content of cell B3 equals the content of cell B6, therefore the content of cell B7 needs to be copied to cell B4. Cell D3, however, does not match any cell in row 6, therefore cell D4 should get the value 0 (zero).
It may seem trivial, but in reality I have about 2000 species and 200 different sub-samples, so any help you can give will be most appreciated!  

RE: Unifying two lists with different lengths

(OP)
Perfect. Thanks a lot!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources