My approach would be to utilize the AutoFilter feature to make the
separations of the lists and the SUBTOTAL formulas to do the math....maybe
all run by macros is I had to do it very often....

Vaya con Dios,
Chuck, CABGx3


"Kirk Pepper" wrote in message
...
This is the worksheet I have.
What I need to do is Compare E and F -if there is a 2 in E and a 2 in F, I
want the name in G copied to a chart that will show the percentage of
people
in the same
Census and Block groups and give their names.
I also need to show the percentage that does not match and who they are.
I
have tried to modify almost every function available but cannot obtain the
desired result.
Please help O Noble knower's of that which eludes me.
Thank You
Colum E Colum F Colum
G
census group Block Group Name

2 2 Ashley, Jordan
2 2 Banks, Victoria
2 1 Beard, Frederick
2 2 Beard, Stephanie
2 2 Bixby, Michael
2 2 Bosco, Dominick