entering info into different worksheets

> I need it to work over a selection of at least 30 groups and so the
> phrase to be automatically deleted from the original list.

Try this slightly revised approach to achieve the above ..

See sheet: Y in the attached sample:
http://www.savefile.com/files/6659952
Extracting_Text_Exceptions.xls

Source data is assumed within A2:A50

List the "exclusion" phrases within B1:B40, eg: gold, interest rate, etc
(I've catered for up to 40 exclusion phrases. Enter in any order within
B1:B40)

Put a label in C1: "leftovers"

Place in C2:
=IF(ROW(A1)>COUNT(D:D),"",INDEX($A:$A,MATCH(SMALL(D:D,ROW(A1)),D:D,0)))

In D2:
=IF($A2="","",IF(SUMPRODUCT(ISNUMBER(SEARCH($B$1:$B$40,$A2))*($B$1:$B$40<>""))>0,"",ROW()))

(Leave D1 empty)

Select C2:D2, fill down to the last row of data expected in col A, i.e. to A50

Col C will return the required "leftovers", viz. items from col A which do
not contain the phrases indicated within B1:B40, with all extracts neatly
bunched at the top.

Replace SEARCH with FIND in the criteria col D if you want the phrase search
to be case sensitive. SEARCH is not case sensitive.

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"exiled" wrote:
>
> Hi Max
>
> Many thanks for the tip.
>
> Unfortunately it doesn't do what I require.
>
> I need it to work over a selection of at least 30 groups and so the
> phrase to be automatically deleted from the original list.
>
> Do you have any ideas, another formula or macro.
>
>
> --
> exiled
> ------------------------------------------------------------------------
> exiled's Profile: http://www.excelforum.com/member.php...o&userid=35619
> View this thread: http://www.excelforum.com/showthread...hreadid=553972
>
>

Typo in line:
> Select C2:D2, fill down to the last row of data expected in col A, i.e. to A50

"to A50" should read as: "to D50"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---