Filter data from two worksheets from same excel file

  • Thread starter Thread starter anu
  • Start date Start date
A

anu

i have a set of account numbers in 2 worksheets( created at diff dates). i
want to find out the ones which are not there in the earlier. Both worksheets
are saved in a single file. The account numbers are of 11 digits and the each
sheet contains hundreds of such account numbers
 
To compare entries in Column A of sheet2 with entries in Column A Sheet1
in your sheet2 (new column G) enter in first data row(say G2))

=COUNTIF(Sheet1!A:A,Sheet2!G2)=0

and Copy down as far as is needed

FALSE = These values are on Both Sheets
TRUE = These values Are NOT on Sheet1
 
Back
Top