compare Excel sheets

Hi,

I've one Excel sheet with a list of applications and another one with a list of Computer names and the installed Software on everyone. I Need a sheet with all Computer names which have any Software installed of the first list. have someone any idea?
EneboerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Anthony MellorConnect With a Mentor Chartered AccountantCommented:
here's one way to do it:

helper column-vlookup-pivot results.
Software-Example-Pivot.xlsx
0
 
Milind KoyandeCommented:
Hello,

You can use Vloopup function of Excel to compare an merge to sheets, but for that you will have to copy the content of second list to a sheet of first list.

Check following links for more help:
http://www.techonthenet.com/excel/formulas/vlookup.php
http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm
http://office.microsoft.com/en-in/excel-help/vlookup-HP005209335.aspx
0
 
Anthony MellorChartered AccountantCommented:
MS Query using a Join, will work on itself within one file.

Alternatively VLookups will do it, but the above has no limits compared to Vlookup.
If small volume then maybe vlookups, if large volume then MS Query
I think we need to see the layout to actually write anything without guessing.

Powerpivot would do it too, but that's maybe a sledgehammer to crack a nut.

Upload an example for more please.
0
 
EneboerAuthor Commented:
i've uploaded an example.
Software-Example.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.