Hi experts,
I want to write a formula like wise : Where ever there is "Model" word,
next to "Model", the Part list should list accordingly in sequence. I have
attached in details.
I am struggling in writing formula. Please help.
Regards,
Nitya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce
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
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