Page 1 of 2 1 2 LastLast
Results 1 to 10 of 16

Thread: Percentages with 3 columns

  1. #1

    Percentages with 3 columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    What do you mean by "find"? Do you want to highlight, add a flag in a column? Count Matches? Sum Matches?


  3. #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. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Can you attach a sample workbook? No confidential info please.


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

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Click Go Advanced below the Reply box, then the paperclip icon, then browse and upload the file.


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

  8. #8
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    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. #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. #10
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Yes, I mean a helper column. Those are cell references.

    See attached.
    Attached Files Attached Files


Page 1 of 2 1 2 LastLast

Posting Permissions

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