If you are going to use Jonmo1's code (3 function calls to 6 for Mike's), and if you plan to copy it down where Column A's cells are blank (perhaps in anticipation of working against future data), then you might want to consider this version of it (returns "" instead of a #VALUE! error)...Many thanks to both of you for your awesomeness!