Thanks, Catalin. the one you updated was better. I used ABS(A2)-TRUNC(A2) and it is longer. Thank you. Regards, Aye
Thanks, Catalin, It works with ABS. Much Appreciated. Regards, Aye
Thanks for reply, Catalin, Please see attached for my base figures and expected result. I just want a formula to work for all scenarios. thank y...
Many thanks, Lionel. Much appreciated it. Kind Regards, Aye
Many thanks for your reply, Anders. ofcourse, Index Match works fine. I am really appreciated. I will try to use Tubular format as per your adiv...
Many thanks, Sunny. It is a great help. the formula for Bill will be a useful one too. I do not have the numbers at the back so far. thank yo...
Many thanks, Lionel. Regards, Aye
Many Thanks, Mynda. Regards, Aye