Subject: Re: $$Excel-Macros$$ Unique value formula required
Hi,
Also try below array formula,
=IFERROR(INDEX($C$2:$C$25,MATCH(0,COUNTIF($E$1:E1,$C$2:$C$25),0)),"")
On Mon, Jun 4, 2012 at 2:15 AM, NOORAIN ANSARI wrote:
> Nice Solution Mahesh.
>
>
> --
> Th
Hi,
Also try below array formula,
=IFERROR(INDEX($C$2:$C$25,MATCH(0,COUNTIF($E$1:E1,$C$2:$C$25),0)),"")
On Mon, Jun 4, 2012 at 2:15 AM, NOORAIN ANSARI wrote:
> Nice Solution Mahesh.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.co
Nice Solution Mahesh.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Sun, Jun 3, 2012 at 1:53 AM, Mahesh parab wrote:
> Hi Avinash
>
> Perhaps ..! you can use below Array formula with dynamic name range
> and without any helper column
>
Hi Avinash
Perhaps ..! you can use below Array formula with dynamic name range
and without any helper column
=IFERROR(INDEX(DESIG,MATCH(0,COUNTIF($F$1:F1,DESIG),0)),"")
DESIG refers to Dynamic Name Range : =OFFSET(Sheet1!$C$2, 0, 0,
COUNTA(Sheet1!$C:$C), 1)
Use ctrl+shfit+Enter to enter formul
Hi NOORAIN,
Thanks for your help man both the formula and macro works fine.
you are just awesome man simply great only 5 lines of code and doing
exceptional task.
salute for your logic and your knowledge.
not just words ! :)
simply great.
Regards,
Avinash
On Friday, June 1, 2012 11:17:
Dear Avinash,
Please try it with ctrl+shfit+Enter
*=INDEX($D$2:$D$21,SMALL(IF($A$2:$A$21=1,ROW($D$2:$D$21),""),ROW(A1))-1)*
See attached sheet
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 1, 2012 at 10:59 PM, Avinash wrote:
> Hi Excel
