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 Excel?
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 nityanandadole...@gmail.com wrote:
Hi experts,
I want to write a formula like wise : Where ever there is
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 nityanandadole...@gmail.com wrote:
Thanks experts,
I made it: =IF(E6=Model,INDEX($A$2:$A$11,COUNTIF($E$5:E5,E6)+1),)
if you have any