How do I do a function that says if A=B put 1 (if there are 2 in a column put
2 and so on).

I have a worksheet that I am trying to compare to another worksheet. If the
same support group name is used on worksheet 1 then total on worksheet 2.
There are 326 support groups that could have more than one entry on worksheet
2 or potential could have 0. Can ya help this southern girl out?