Not sure if it's better, but certainly fractionally simpler
=IF(E6="Model",INDEX($A$2:$A$11,COUNTIF($E$6:E6,E6)),"")
On Fri, Jul 18, 2014 at 1:45 PM, Nitya wrote:
> Thanks experts,
>
> I made it: =IF(E6="Model",INDEX($A$2:$A$11,COUNTIF($E$5:E5,E6)+1),"")
>
> if you have any better formula th
Thanks experts,
I made it: =IF(E6="Model",INDEX($A$2:$A$11,COUNTIF($E$5:E5,E6)+1),"")
if you have any better formula than please please share me.
On Fri, Jul 18, 2014 at 12:59 PM, Nitya wrote:
> Hi experts,
>
> I want to write a formula like wise : Where ever there is "Model" word,
> next t
