Thanks .
I have modified the formula to suit my requirement as follows; SMALL(IF(ISNUMBER(SEARCH((Report!B1),C2:C28,1)),ROW(1:28),ROW(1:28)) Thanks buddy for giving me the direction. Regards, C.G.Kumar On Mon, Apr 18, 2011 at 3:33 PM, STDEV(i) <setiyowati.d...@gmail.com> wrote: > plese check the attached workbook, and see if it helps. > > > *ARRAY FORMULA* > =small(if(left(C2:C29,len(F4))=F4,row(1:28)),row(1:28)) > > FORMULA > =IF(ISERR($D6),"",OFFSET(A$1,$D6,0)) > > > > > On Mon, Apr 18, 2011 at 3:16 PM, C.G.Kumar <kumar.bemlmum...@gmail.com>wrote: > >> PFA sample File. >> >> ---------- Forwarded message ---------- >> From: C.G.Kumar <kumar.bemlmum...@gmail.com> >> Date: Mon, Apr 18, 2011 at 1:45 PM >> Subject: SEARCH FUNCTION >> To: excel-macros@googlegroups.com >> >> >> Dear All, >> >> I intend to generate list based on search of Text String.Sample file >> attached. >> Regards, >> C.G.Kumar >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel