Hi Aligah,
Nicely explained query, though little lengthy but it's ok and well drafted.
I have solved the attached workbook as per your criteria.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On
I am not sure what you mean by fetch, but the easiest way to obtain a
list of just the items that contain "PIPE" or "ELL" would be the
following:
Step 1: Enter the following formula into Cell E4
=IF(ISNUMBER(SEARCH("PIPE",A4)),"PIPE",IF(ISNUMBER(SEARCH
("ELL",A4)),"ELL",""))
Step 2: Copy the fo
