I have an Excel database of some 50,00 lines of test equipment, the
description shows manufacturer, type and model number of tehitem.
I wish to extract (copy to new location) all cells that have a specific type
of item e.g. "Power Supply" from an entry such as "Lambda -LYS-EE-5v Power
Supply" there may be other manufacturers names elswhere
Thanks

If your descriptions are in Col A
then enter this in B1
=IF(ISERROR(FIND("Power Supply",A1)),0,1)
and copy down

Now filter Col B on cells with value 1... This will show all itesm with
"Power Supply" in the description...

You can copy Col B on value zero and delete those rows to be left with the
items you want.

"mahatchma" wrote:

I have an Excel database of some 50,00 lines of test equipment, the
description shows manufacturer, type and model number of tehitem.
I wish to extract (copy to new location) all cells that have a specific type
of item e.g. "Power Supply" from an entry such as "Lambda -LYS-EE-5v Power
Supply" there may be other manufacturers names elswhere
Thanks

Hi,

select your data with titles

1. Choose Data, Filter, Auto Filter
2. Open the auto filter drop down in the type field and choose Custom
3. From the first drop down pick Contains
4. In the box to the right enter Power Supply and click OK
5. Select all the data and copy, move to a new sheet and paste

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mahatchma" wrote:

I have an Excel database of some 50,00 lines of test equipment, the
description shows manufacturer, type and model number of tehitem.
I wish to extract (copy to new location) all cells that have a specific type
of item e.g. "Power Supply" from an entry such as "Lambda -LYS-EE-5v Power
Supply" there may be other manufacturers names elswhere
Thanks

You might want to use SEARCH instead of FIND, so that it is not case
sensitive.

Hope this helps.

Pete

On Jan 6, 4:31*pm, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) &
"hotmail.com" wrote:
If your descriptions are in Col A
then enter this in B1
=IF(ISERROR(FIND("Power Supply",A1)),0,1)
and copy down

Now filter Col B on cells with value 1... This will show all itesm with
"Power Supply" in the description...

You can copy Col B on value zero and delete those rows to be left with the
items you want.



"mahatchma" wrote:
I have an Excel database of some 50,00 lines of test equipment, the
description shows manufacturer, type and model number of tehitem.
I wish to extract (copy to new location) all cells that have a specific type
of item e.g. "Power Supply" from an entry such as "Lambda -LYS-EE-5v Power
Supply" there may be other manufacturers names elswhere
Thanks- Hide quoted text -

- Show quoted text -