Paul,
I suppose we have to agree on the definition of "works."
I was looking at this with "delete rows if the cell in the first column = $" as the sole condition. Where = "$" and = "$ paragraph mark" are two conditions. Mine works with the sole condition "$", yours works with both conditions and works perfectly if that is the goal. Neither works as written for the third condition "$ "
Still it is a clever technique and thanks for sharing.
|