Function VBA

[vasim]

How can I create a function/add in for this formula ={INDEX(B:B,SMALL(IF($A$2:$A$10 =$D$2,ROW($A$2:$A$10)),ROW(A1)))}

 

[Debraj]

Hi Indian,


Please provide us detail, what exactly the this formula does, and what problem you are facing for the same..so that we can help you better,


BTW: You can create a NAME, (Name Manager > New )

Name : Indian

Refers to : =IFERROR(INDEX(Sheet1!$B$2:$B$10,SMALL(IF(Sheet1!$A$2:$A$10 =Sheet1!$D$2,ROW(Sheet1!$A$2:$A$10),""),ROW(Sheet1!A1))),"")


and use the formula as =Indian


and

if you are searching for similar Function or UDF..

you can adapt ColinRead's formula vbaVlookup and detail in my post/File.. in the same page..


http://chandoo.org/forums/topic/multi-return-of-data-for-one-name-with-vlookup


Regards,

Deb

 

[shrivallabha]

If anything, VBA UDF will be slower than your Array formula.


So there must be some good reason why you want to do this. Deb has suggested a name based alternative which will be better than VBA in terms of speed.