Filter data from two worksheets from same excel file

[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

 

[JMay]

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

 

[JMay]

Sorry, better make that:

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