| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find values not listed in two sheets
Hi,
I have values on two sheets but sheet A is not complete I am trying to see which ones are missing. Example: Sheet A Sheet2 Result 1 Cost Id Cost Id 2 30252 30252 3 30254 30253 Not in Sheet A 4 30256 30254 5 30257 30255 Not in Sheet A 6 30279 30256 7 30257 8 30258 Not in Sheet A 9 30259 Not in Sheet A 10 30260 Not in Sheet A |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find values not listed in two sheets
=IFERROR(MATCH(A2,Sheet A!$A$2:$A$6,0),"Not in Sheet A")
Where A2 contains the Cost ID on Sheet 2 and SheetA!$A$2:$A$6 is the range containing Cost ID on Sheet A. Adjust as needed. "Mary" wrote: Hi, I have values on two sheets but sheet A is not complete I am trying to see which ones are missing. Example: Sheet A Sheet2 Result 1 Cost Id Cost Id 2 30252 30252 3 30254 30253 Not in Sheet A 4 30256 30254 5 30257 30255 Not in Sheet A 6 30279 30256 7 30257 8 30258 Not in Sheet A 9 30259 Not in Sheet A 10 30260 Not in Sheet A |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find values not listed in two sheets
if Mary has a version of Excel earlier than 2007 the iferror funciton will
not work try =if(iserror(MATCH(A2,Sheet A!$A$2:$A$6,0)),"Not in Sheet A","") "BoniM" wrote: =IFERROR(MATCH(A2,Sheet A!$A$2:$A$6,0),"Not in Sheet A") Where A2 contains the Cost ID on Sheet 2 and SheetA!$A$2:$A$6 is the range containing Cost ID on Sheet A. Adjust as needed. "Mary" wrote: Hi, I have values on two sheets but sheet A is not complete I am trying to see which ones are missing. Example: Sheet A Sheet2 Result 1 Cost Id Cost Id 2 30252 30252 3 30254 30253 Not in Sheet A 4 30256 30254 5 30257 30255 Not in Sheet A 6 30279 30256 7 30257 8 30258 Not in Sheet A 9 30259 Not in Sheet A 10 30260 Not in Sheet A |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding zero values on all sheets & by default on new sheets | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
| Find values from cells in multiple sheets | Excel Worksheet Functions | |||
| how do i find which sheets contain links? | Excel Worksheet Functions | |||
![Mary[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
