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? |
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 |
lookup vaules which are not exist in a table
Big thanks. :))))
|
lookup vaules which are not exist in a table
Big thanks. :))))
|
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com