Doh! I was reading the newsgroup in a busy lobby, and forgot to read your
whole post.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"JE McGimpsey" wrote in message
...
That's essentially what the third example does, though there are more
efficient ways, especially if the columns aren't contiguous.
In article ,
"Jon Peltier" wrote:
Or you could read the ranges into VBA arrays, and do the necessary
calculations on them. I wouldn't bother with sumproduct I don't think.
I'd
just loop, do my comparisons within the loop, and keep score with a
counting
variable.