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) wrote:
> plese check the attached workbook,
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 wrote:
> PFA sample File.
>
> -- Forwarded message --
> Fro
