Filter data from two worksheets from same excel file
 

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

Filter data from two worksheets from same excel file
 

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



"anu" wrote:

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

Filter data from two worksheets from same excel file
 

Sorry, better make that:

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



"JMay" wrote:

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



"anu" wrote:

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