Exracting unique text from different cells

qexcel

New Member
Joined
Nov 23, 2005
Messages
1
Hello Iam not sure if there are any straight fwd way of doing this is in excel. Seeking the help of gurus for a response..

Here is the task I have. Iam trying to find if the Key words listed below in the Keywords Data header are present in the cells from A1...(These are descriptions) If I find any of the keywords anywhere from A1:A2, i want to add Y if not N

Keywords Data
Keywords: TWIN DCVD SACVD TEOS NEZ RPS
Available: Y Y Y N Y Y

A1 KIT, SIMPLE CATHODE, BASE, DCVD, 200MM, RPSGECO
A2 CONFIGURATION, SPARES, RPS GECO
A3 KIT SHIP, COMBO CHAMBER, TEOS LID CONVERTER
A4 KIT, RPS CHAMBER, UNRELEASED PARTS GECO A4
A5 R2-ESC,200,SIMCAT,CHEM 513,SUP,50/XT/52,ALL POS
A6 KIT LID COMMON 200MM TWIN CH PRODUCER

:(
 

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

Assuming that the keywords are in the range G1:L1 then array enter (ctrl, shift, enter) the formula
Code:
=IF(MAX(ISNUMBER(FIND(G$1,$A$1:$A$6,1))*1),"Y","N")
in G2 and copy to F2:L2

I get the results Y Y N Y N Y


Tony
 

Forum statistics

Threads
1,078,121
Messages
5,338,350
Members
399,228
Latest member
Bucephalas

Some videos you may like

This Week's Hot Topics

Top