EXCEL 2007

Closed
p040775 - Jul 28, 2010 at 01:15 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 04:49 PM
Hello,



I have two excel 2007 files. Both files have same columns but different dates. What I need to do is to compare the data in both files and in file 2 highlight the data that is the same as in file 1. How do I perform this task?

4 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 28, 2010 at 05:55 PM
did you see VLOOKUP
0
I am very new to this and have no clue how to even do a VLOOKUP or what criteria to enter!
0
Both sheets have same data however, one file is larger than the other as they are for different days. What I am trying to do is look at the data in the bigger sheet and identify the data from sheet 1 (smaller sheet) that is duplicated in sheet 2. This is an example of the file data I am using. HELP!


00757 McKe, Nadine (ASC/WAH)
16098 Frann, Khat (WCMP)
16101 Fernz, Rama (WAH)
16105 Drumm, Phls
16136 Brou, Lara
16178 Woe, Katr (ASC)
16342 Carpe, Mari (WCMP)
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 30, 2010 at 07:37 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0
I have posted the two sample files to. What I would like to do is run a comparison on the 8/30 file to find all duplicates that are in the 7/5 file and to highlight those that are duplicate in both files. I have posted the two files to :
https://authentification.site/files/23594967/agentcheckin_070510_test.xls
https://authentification.site/files/23594968/agentcheckin_083010_test.xls
0
Both files have been uploaded : https://authentification.site/files/23594968/agentcheckin_083010_test.xls and https://authentification.site/files/23594967/agentcheckin_070510_test.xls What I would like to do is find all duplicated in 8/30 file that are in 7/5 file and highlight the duplicates on the 8/30 file
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 30, 2010 at 04:49 PM
Highlighting directly is not possible. What you can do is locate what are also in your other book. Once you have that you can highlight the cell/row

you can add to an available column this

=IF(ISERROR(MATCH(A12,'C:\Users\shamikh\Downloads\[agentcheckin 070510 test.xls]Sheet1'!$A:$A,0)), 0,1)

This will show a 1 if the value in cell A12 is also in the other book (070510). It will show a 0, if it is not
0