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
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
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Unifying two lists with different lengths
RE: Unifying two lists with different lengths
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
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Unifying two lists with different lengths