Then I am confused where any of these numbers come form

ColA |ColB |ColC |ColD |ColE|ColG
Apples |Off |Coyotes |Apples |Off |2
Bannanas |Apples |Elephants|Bannanas|Off |1
Coyotes |Coyotes |Off |Off |Off |3
Elephants|Elephants|Off |Elephants|Off |4

Whys isn't it 1,1,1,1?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SteveC" wrote in message
...
... keeping in mind that the variables that we are matching to Col A are
randomly dispersed or even omitted in Col B, Col C and Col D, and we are
counting consecutively left to right...