Mac Excel 2011 formular Help

Discussion in 'Mac Apps and Mac App Store' started by ichinisan, Aug 1, 2011.

  1. ichinisan macrumors newbie

    Joined:
    Nov 12, 2006
    #1
    Hi,

    I have a list of numbers written in Excel. I don't want to waste hours to count to count the numbers to have 250 as a result. My question is I want to have 250 as a result and i want to know which numbers sum together with which number to have 250. Like a+b+ ... +x = 250.

    Thank you for your help.
     
  2. blevins321 macrumors 68030

    Joined:
    Dec 24, 2010
    Location:
    Winnipeg, MB
    #2
    Hmm I don't know that there is a way to do this totally without macros. But here might be a slight workaround.

    Have in a column to the right of the list a cumulative sum of all the numbers that have come in the rows above. Then apply conditional formatting to that column that says if the number is above 250, make the text white. The final visible number will be the correct one.
     
  3. kreach macrumors member

    Joined:
    Jan 11, 2010
    #3
  4. ichinisan thread starter macrumors newbie

    Joined:
    Nov 12, 2006
    #4
    thank you for your fast answer blevins. Maybe I didn't explain well because of my bad english.

    In a formular 250 is known number but I want to know the unknown numbers. And those numbers will be highlighted or move to a separate list.
     
  5. ichinisan thread starter macrumors newbie

    Joined:
    Nov 12, 2006
    #5

Share This Page