Compare data in two Excel Workbooks

[Ingo444]

Hi all-

I have two Excel workbooks and each workbook has two columns: project title and project ID. The workbooks do not contain the same number of rows (one has extraneous information). How can I make sure that the titles and IDs in workbook 1 have matching titles and IDs in workbook 2?

I have no VBA experience, and my only "technical" (I use that term loosely) experience has been in FileMaker...so, I'd really appreciate some advice. Thanks so much!

 

[kpetursson]

can you add a column to the work sheet containing the data you want to check?

is the data in two seprate file, or just different sheets in the same file?

same file solution
If so you could simply use the countif() function
a b c
1 name1 =countif(Sheet2!$A$1:$A$100,A1)
2 name2 =countif(Sheet2!$A$1:$A$100,A2)
3 name3 =countif(Sheet2!$A$1:$A$100,A3)

the formula will return the number of times it finds the value in A1 in the list on sheet2.

different files
change the formula to this
=countif([book2]sheet2!$A$1:$A$100,A1)

Hope this helps.

Kevin Petursson