Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compare columns and get a percentage
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 knowers 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 |