| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup vaules which are not exist in a table
I have column A, B, C. I want to know what are the values in column A that not exist in column B&C.
Anyone can help this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup vaules which are not exist in a table
Hi,
Am Tue, 26 Nov 2013 06:39:42 -0800 (PST) schrieb : I have column A, B, C. I want to know what are the values in column A that not exist in column B&C. in D1: =IF(COUNTIF($B$1:$C$100,A1)=0,"no match","match") and copy down Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup vaules which are not exist in a table
Big thanks. :))))
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup vaules which are not exist in a table
Big thanks. :))))
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup to see if multiple values exist | Excel Worksheet Functions | |||
| Does a formula exist that will lookup on ALL tabs, not just one. | Excel Discussion (Misc queries) | |||
| How do I Clear old Pivot Table Fields that no longer exist | Excel Discussion (Misc queries) | |||
| Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist | Excel Programming | |||
| Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions | |||
Hybrid Mode
