IF Function for a specific word found in a column of cells

[ddicicco]

I have a spreadsheet where one column lists all the skills of certain employees. Is there a way I can return a "1" in the next column if that skill is listed or a "0" if it is not so that I could then filter out all of the "1's".
example skill could be "excel" Thanks

 

[Aladin Akyurek]

Re: IF Function for a specific word found in a column of cel

I have a spreadsheet where one column lists all the skills of certain employees. Is there a way I can return a "1" in the next column if that skill is listed or a "0" if it is not so that I could then filter out all of the "1's".
example skill could be "excel" Thanks

Care to post a 5-row sample?

 

[ddicicco]

Sorry, new at this, how do I post a sample/attach a file?

 

[Oaktree]

See "Download Colo's HTML Maker..." at the bottom of this page.

 

[ddicicco]

aaaa.xls
	A	B	C	D	E
1	Skills Summary	Excel Listed? (1 or 0)
2	Microsoft Word 2000 (and MS 2000 Millennium Edition), Excel, PowerPoint, Access, Outlook, Word Perfect,Can operate IBM (both Windows 95, 98 and 2000 operating systems), Macintosh computers, desktop and laser printers and scanning equipment.
3	Project management; preparation and analysis of project plans including: Preparation and analysis of project budgets; Business development.; Analytical, quantitative and problem solving skills. - Excellent knowledge of MS Word, Excel, Access as well
4	Siebel - programming, developing, gathering requirements and testing Client/Server applications, HTML
5	Has over five years experience working within financial institutions, planning for sub-projects, leading projects, and testing initiatives, some risk rating experience.
6	Six Sigma Green Belt and Red Belt certifications; Visual Basic (v6, .NET); PS/SQL; MS Access, Visio, Project; Telecom, POS,
NA Resources

[/url]

 

[Aladin Akyurek]

aaaa.xls
	A	B	C	D	E
1	Skills Summary	Excel Listed? (1 or 0)
2	Microsoft Word 2000 (and MS 2000 Millennium Edition), Excel, PowerPoint, Access, Outlook, Word Perfect,Can operate IBM (both Windows 95, 98 and 2000 operating systems), Macintosh computers, desktop and laser printers and scanning equipment.
3	Project management; preparation and analysis of project plans including: Preparation and analysis of project budgets; Business development.; Analytical, quantitative and problem solving skills. - Excellent knowledge of MS Word, Excel, Access as well
4	Siebel - programming, developing, gathering requirements and testing Client/Server applications, HTML
5	Has over five years experience working within financial institutions, planning for sub-projects, leading projects, and testing initiatives, some risk rating experience.
6	Six Sigma Green Belt and Red Belt certifications; Visual Basic (v6, .NET); PS/SQL; MS Access, Visio, Project; Telecom, POS,
NA Resources

[/url]

B2, copied down:

=ISNUMBER(SEARCH(" excel "," "&SUBSTITUTE(A2,","," ")&" "))+0