Sorry to jump back to this, but I have found an issue with Mynda's solution: although the original data only had Warnings for three of the items (2, 7...
I figured it was something like that, Phil: I didn't appreciate the difference between an empty string and a blank cell. Thanks for the quick reply an...
Sorry for not finding that sooner, Mynda - noobie error!
I have opened Mynda's file, but don't see a solution in it (there is no query) - it looks to be just the original data. Maybe I should look up this id...
Hi Phil and Mynda, Thank you both very much for the solutions. I have gone through Phil's so far, but it's taking me some time to appreciate what ...