An observation .. think from where you're reading this [
"excelbanter.com" ], the formula below has been slightly distorted. There's
a missing "less than" symbol just after the COUNTIF(...), before the "1".
Ensure that this missing symbol is inserted. Anyway, the sample file [link
posted earlier] contains the working implementation