This content has been marked as final. Show 2 replies
I have a problem to solve !!
enclosed attached excel file trans
first column is name
second is new trans if y it is new
third id transnum
I need to add the forth column GroupNum ,
a group gets GroupNum , where newtran='y ' , GroupNum=TranNum
all lines that follow this line until the next 'y' with same Name ( not includes )
All Lines get the GroupNum from the line which newtran = 'y'
the enclosed file expalin it better .