try this formula or attached file
=IFERROR(INDIRECT("d"&SMALL(IF(IF(COUNTIF($E$3:$E$5,$D$3:$D$8)=0,1,0)*ROW($D$3:$D$8)>0,ROW($D$3:$D$8)),ROW(A1))),"")
From: santosh subudhi
To: excel-macros
Sent: Thursday, August 22, 2013 4:55 AM
Subject: $$Excel-Macros$$ Ex
attached the solution sheet with desired result.
>
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> Date: Thu, 22 Aug 2013 09:58:48 +0530
> > Subject: Re: $$Excel-Macros$$ Extract Names which are not common
> > From: gawlianil8...@gmail.com
> > To: excel
Hi Anil,
Thanks for your prompt reply.
However the solution did't solve my problem.
I have attached the solution sheet with desired result.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
Date: Thu, 22 Aug 2013 09:58:48 +0530
> Subject: Re: $$Excel-Macros$$ Extract Names which
Dear Santosh,
Pl find attached herewith.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Aug 22, 2013 at 4:55 AM, santosh subudhi
wrote:
> Hi Group,
>
> Is it possible to extract the data which are not common between t
