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
Hi Excel's,
I want to retrieve unique records from the data. 1st preference will be
formula.
otherwise if anyone can help me with the macro or function will also
welcome.
please find attached sheet for better understanding.
Regards,
Avinash
--
FORUM RULES (986+ members already BANNED for
