compile list based on cell contents

[murthigvs]

dear friends,

i have a list in xls (see attached). from this i would like to make a shorter list. if any of the cells contain the term 'magnetic resonance', i would like the contents of that cell to be added to this new list. can you pl help.

thanks

[NeedForExcel]

Hi!

Put this in Cell B2 & Commit Using Ctrl + Shift + Enter and Drag Down -

Please Login or Register  to view this content.

Hope it helps!

Deep

[micope21]

Hi

Cell B1 you type any search keyword?
magnetic resonance or Head or Views Etc.

B2

Please Login or Register  to view this content.

This is array formula: Press same time: Ctrl+Shift+Enter, NOT ENTER. Copy down

See the file!

File sample is excel 2003

This formula only work from Excel 2007-2013

You on excel 2010? I save it to xlsx

Regard

[murthigvs]

thanks. much appreciated.