Formula generating a column of data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I work for a Washington, DC advocacy organization, and I'm running our annual
lobby day; We've got a big spreadsheet that includes information about what
committees Congressmen are on and their "rank" on a whole set of issues.
People who vote the correct way on an issue are a "1"; people who don't are a
'5'; swing votes are '3's'. We have a number of issues on our agenda, and I'm
trying to automatically generate a list of what two issues people should
discuss with their Members of Congress when they come to town. For instance,
if a Congressman is a member of the Commerce Committee, and is ranked a 2, 3,
or 4 on air quality, then our top priority issue with that Member should be
air quality. If the person is ranked a 2,3, or 4 on energy issues, that
should be the secondary issue. How do I set this up?
 
The layout has row labels with the names of different members of congress and
the columns are labeled with issues and information (such as committee
membership) on which they're ranked.

Thank you for your help!

Glenn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NPR music station. 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Show a subform based on data in subform 2
A mini review of Iphone 12 mini 4
I want to sort a column of data which is the SUM of three cols 1
''What the President Ordered in This Case Was a Crime" 50
Switch() Clause within the same field, different record?: 1
Rank a list of proposals 3

Back
Top