Thanks a lot Noorin bahi
On Wed, Jan 16, 2013 at 6:25 PM, NOORAIN ANSARI wrote:
> Dear Amar,
>
> Please try it..
>
> =INDEX($E$3:$E$65,SMALL(IF($D$3:$D$65=K$3,ROW($E$3:$E$65),""),ROW(B1))-2)
> with ctrl+shift+enter
>
> see attached sheet for more clarity.
>
>
>
> --
> With Regards,
> Noorain Ansa
Hi All
Pls Solution for above attached sheet.suggest any simple formula pls.
Amar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem
