Hi Sam,
its realy Great ! super
Thanks Sam
Regards
chandru
On Thu, Feb 16, 2012 at 11:39 PM, Sam Mathai Chacko wrote:
> Yeah I understand that, you just had to use the formula as I said. Here's
> the attachment...
>
>
>
> =IFERROR(INDEX(database!A$1:A$2500,SMALL(IF(LEN(SUBSTITUTE(UPPER(dat
Use this formula as an array in c8 and drag across
=IFERROR(INDEX(database!A$1:A$2500,SMALL(IF(LEN(SUBSTITUTE(UPPER(database!$A
$1:$A$2500),UPPER(Sheet2!$E$3),""))mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Thursday, February 16, 2012 7:34 PM
To: excel-macros@google
