Hi
I have data from that I want from Asg Num Column each Number If Any code mention in same Row & If any code mention then that date I want as start Date then where R is mention then before 1 day that date I want as End Date.
2.If Any code is not given Only R is mention then that date I want as start date
3.If only Code is given & R is not mention then 1st Code Date I want as Start Date
4.Each Number if any Comment is mention then that comment & File name I want
I have mention in Expected Result sheet what type of data I want
I have data from that I want from Asg Num Column each Number If Any code mention in same Row & If any code mention then that date I want as start Date then where R is mention then before 1 day that date I want as End Date.
2.If Any code is not given Only R is mention then that date I want as start date
3.If only Code is given & R is not mention then 1st Code Date I want as Start Date
4.Each Number if any Comment is mention then that comment & File name I want
I have mention in Expected Result sheet what type of data I want