compare - comparing two columns in excel (VLOOKUP not working) -


i have been breaking head problem since morning , haven't found solution. please give valuable pointers if possible, can try find solution.

i have 2 sets of data- old list , new list. wish compare new list( comparing name , country together) old list, since new list has few additional entries. later on, create new list common entries both old , new list , add new entries below common ones ( if possible, else manually later on excel tell me new entry). sorry, if has not been explained, maybe following illustration helps

 old list             item no. name          country   1  apples          italy     3  banana          spain     4  grapes          slovakia      5  pineapple   greece    8  banana          czech republic    14 apples          india     23 pineapple   hungary   19 peach           usa   2  strawberries    france     new list         item no. name       country   4  grapes       slovakia    mango        pakistan     14 apples       india   oranges      mexico   19 peach        usa      2  strawberries france   1  apples       italy    3  banana       spain    23 pineapple    hungary     avocado      netherlands       expected output:         list common serial no.s based on common names both lists   item no.name           country   4  grapes          slovakia  14 apples          india  19 peach           usa  2  strawberries    france  1  apples          italy  3  banana          spain  23 pineapple   hungary mango           pakistan oranges         mexico     avocado         netherlands

as can seen in attachment, have old list item no., name , country. let's assume item numbers have been classified based on code words. in second list, there again item no.s, name , country item numbers haven't been filled ( since new , have not yet been sorted). now, want excel compare names , countries of both data , provide common item no. output if there match. if there no match, excel tell me new entry. looked on various forums , realized vlookup command allows me search on name or country give me common entries of names/countries respectively not item no.s. there formula me solve problem?

just paste list together, sort it, , remove duplicates. removing duplicates built-in excel starting version 2007, find in data ribbon (see http://office.microsoft.com/en-001/excel-help/filter-for-unique-values-or-remove-duplicate-values-hp010073943.aspx).


-

Comments

Post a Comment

Popular posts from this blog

how to proxy from https to http with lighttpd -

i have internal site (192.168.2.1) accessible http on different server run public web-server using lighttpd. can make internal site accessible outside work follows $http["host"] == "internal.example.com" { ... proxy.server = ( "" => ( "internal" => ( "host" => "192.168.2.1", "port" => 8000 ) ) } this works, use https outside world. question is, how can proxy going https http ? i've tried this: $server["socket"] == ":443" { $http["host"] == "internal.example.com" { ... proxy.server = ( "" => ( "internal" => ( "host" => "http://192.168.2.1", "port" => 8000 ) ) } } but doesn't seem wor...
Read more

android - Automated my builds -

i have multiple app , android project want automated in build , release sequence. have ant script build , create apk of app. want have 1 script or ant file start build sequence app. maybe don't konw search, can't find easy documentation on ant. the point of use jenkins ant (or maven, i'm not sure of difference between them now) automated build sequence when people commit on project. any int appreciated maven dependencies (over ant) don't need pass around jars. recommend maven on ant day. syntax , overall process easier understand, @ end of both build tools. if able to, more recommend upgrading gradle. easy create different build types , create them ./gradlew assemble here project jake wharton can see power of gradle. there release , debug build, can make lot more if like. https://github.com/jakewharton/u2020 here android docs gradle http://tools.android.com/tech-docs/new-build-system/user-guide . if can't find looking here, check out main grad...
Read more

python - Flask migration error -

i've got application build on flask , wanted create new migration today. when run $python manage.py db upgrade i got message raise util.commanderror('only single head supported. ' alembic.util.commanderror: single head supported. script directory has multiple heads (due branching), must resolved manually editing revision files form linear sequence. run alembic branches see divergence(s). so run command $alembic branches no config file 'alembic.ini' found, or file has no '[alembic]' section any clue on about? the error messages coming alembic, use command form alembic <command> , integrating flask coming flask-migrate, need use form python manage.py db branches . to resolve multiple branches, make 1 of branches point down other branch upgrade graph straight line. see alembic's docs on branches: http://alembic.readthedocs.org/en/latest/branches.html
Read more