hi all,
i have gone through quite a few posts unfortunately i haven't been able to create the solution i would like to have. this is because I have found it hard to explain exactly what i require. hence i have attached an excel file with input and the desired output. if anyone of u can go through and suggest a solution would be really helpful.
Bookmarks