hi richard.

i tried the formula but it does not seem to work. can you have a look at the excel file uploaded above and kindly check why it is not working. i would be grateful my friend.