# Thread: Percentages with 3 columns

1. ## Percentages with 3 columns

I am using Excel 2008 on a MAC. I have 3 columns: Census tract, Total number of people, and People living below the poverty line. I want to find all of the census tracts where 50% or more of the people live below the poverty line. Help! (also posted this in "Other General Questions")

2. What do you mean by "find"? Do you want to highlight, add a flag in a column? Count Matches? Sum Matches?

3. I need to identify those tracts where 50% or more of the people live below the poverty line, then make two new columns... One that shows the identified tract numbers and the other that shows the number of people living below the poverty line within each tract.

4. Can you attach a sample workbook? No confidential info please.

5. Yes, I am happy to attach a sample workbook, but I don't see how to do that!

6. Click Go Advanced below the Reply box, then the paperclip icon, then browse and upload the file.

7. The columns I am working with are A, B and C

8. Ok, if I understand correctly, try this.

First, add a helper column to identify the matches.

In F4 enter formula:

=IF(C4/B4<=0.5,COUNT(F\$3:F3)+1,"")

copied down.

Then in say, I2:

=IFERROR(INDEX(\$A\$4:\$A\$190,MATCH(ROWS(I\$2:I2),\$F\$4:\$F\$190,0)),"")

copied down same distance as database table.

in J2:

=IFERROR(INDEX(\$C\$4:\$C\$190,MATCH(ROWS(I\$2:I2),\$F\$4:\$F\$190,0)),"")

copied down same.

These can be Cut and pasted in Sheet2, if desired.

Is that what you need?

9. Thanks for sending this. Unfortunately, I don't know where to find F4, 12 and J2. By helper column do you just mean a new empty column?

10. Yes, I mean a helper column. Those are cell references.

See attached.

Page 1 of 2 1 2 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•