Consulting

Results 1 to 2 of 2

Thread: Find numbers whose sum is a number given

  1. #1
    VBAX Newbie
    Joined
    Jun 2018
    Posts
    5
    Location

    Find numbers whose sum is a number given

    Find numbers(A4:A121) whose sum is a number given(A2)
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,027
    Location
    See, for example: http://www.msofficeforums.com/excel-...html#post77209. Do note that the calculation effort expands exponentially as more cells (quadruplets, quintuplets, etc.) are added to the mix.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

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