Issue with Advance filter (formula)

[amitkr3855]

Dear Experts Good morning..

Here i have an problem with advance filter (Pick Unique Value)

Now m using this

In C2

=INDEX($A$2:$A$7,MATCH(0,COUNTIF($C$1:C1,$A$2:$A$7),0)) and working fine.

But there is some issue in it.

1. it picks randomly data whereas i need this in sorting (asc/desc)
2. If m doing this with a reference then m not able to do this.
3. also m fail to do this if i get the data Vertically.

Pl. see my sample attachment and help me out

R's
Amit Kumar

[dilipandey]

Hi Amit,

I applied your formula in C2 and got #n/a. suggest you to enter your results manually and I'll try to obtain them using formulas. Thanks.



Regards,
DILIPandey
<click on below * if this helps>

[amitkr3855]

thanx boss for responding..
will wait 4 your revert... :-)

[dilipandey]

Hi amit,

I mentioned

suggest you to enter your results manually and I'll try to obtain them using formulas.

Regards,
DILIPandey
<click on below * if this helps>