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" <SteveC@discussions.microsoft.com> wrote in message
news:9CA3C07B-AC85-4429-8B7D-86B4FF612BDC@microsoft.com...
> ... 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...