| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Data From Master Sheet Into Other Worksheets | Excel Worksheet Functions | |||
| Filter data in one worksheet to other worksheets | Excel Discussion (Misc queries) | |||
| Can I pull data from worksheets with a batch file? | Excel Discussion (Misc queries) | |||
| How do I filter data from a master worksheet to other worksheets | Excel Discussion (Misc queries) | |||
| Analyze & Filter data in a notepad file | Excel Discussion (Misc queries) | |||
Linear Mode
