Find partial text and retrun value in corresponding column
On Wednesday, December 26, 2012 12:44:21 PM UTC-8, wrote:
YEs that works great but it only lists the first instance
offound of the search criteria. Can you show me how to make it
find and list all that it finds?
Here's one way, using E as a helper column.
In E1 put
=IF(ISERROR(FIND($C$1,A1)),"",1)
In E2 put
=IF(ISERROR(FIND($C$1,A2)),"",MAX($E$1:E1)+1)
and copy down past the end of the list.
In D1 put
=IF(ROW()MAX(E:E),"",INDEX(A:B,MATCH(ROW(),E:E,0) ,2))
and copy down past the end of the list.
Hope this helps getting started.
|