Thank you Anders. It's going to be a tedious process using find and replace, but if there is nothing out there, than I have no option. Much appr...
Hi Sunny Thanks for the two conditional formatting options that is really great. Once again thank you! Regards Mel
Hello Sunny You are an Excel geek - thanks for the solution and for correcting my formula. Regards Mel
Hi Sunny Thank you so much for your help. It is great to have someone like you on the forum. I thought ISERROR was the commonly used function t...
Hi Sunny Going back to the index and match formulae - if I want to suppress the #N/A from appearing in a cell how do I do it. I have used the ISER...
Hi Sunny Excellent - I am spoilt for choice with your three solutions. Regards Mel