Welcome Guest
Log In | Register )
You last visited January 24, 2017, 3:40 pm
All times shown are
Eastern Time (GMT-5:00)

Excel help input=output

Topic closed. 3 replies. Last post 8 years ago by pcnut.

Page 1 of 1
PrintE-mailLink
Avatar
Myrtle Beach, SC
United States
Member #18457
July 12, 2005
3433 Posts
Offline
Posted: August 29, 2008, 9:08 pm - IP Logged

Need a formula:

Put one digit in a cell and the next cell produces 3 pre-selected pairs

input              out put

A=7 ...... B= 56, 48, 39      for instant.

 

Thanks

pcnut

"Wisdom is knowing what to do next, skill is knowing how to do it, and virtue is doing it."

                                                                                                                        David Starr Jordan

S.C.'s weekly-indicative random pairs: 05, 12, 13, 16, 18, 23, 34

Enjoy

pcnut

    tiggs95's avatar - Lottery-036.jpg

    United States
    Member #47420
    November 4, 2006
    3930 Posts
    Offline
    Posted: August 29, 2008, 9:26 pm - IP Logged

    Huh?

      Avatar
      New Mexico
      United States
      Member #58526
      February 18, 2008
      683 Posts
      Offline
      Posted: August 29, 2008, 9:37 pm - IP Logged

      Need a formula:

      Put one digit in a cell and the next cell produces 3 pre-selected pairs

      input              out put

      A=7 ...... B= 56, 48, 39      for instant.

       

      Thanks

      pcnut

      Are you saying that for every digit in the input that there exists 3 predetermined pair sets that you want for output?  I think you need to be a bit more specific.

        Avatar
        Myrtle Beach, SC
        United States
        Member #18457
        July 12, 2005
        3433 Posts
        Offline
        Posted: August 29, 2008, 10:01 pm - IP Logged

        Are you saying that for every digit in the input that there exists 3 predetermined pair sets that you want for output?  I think you need to be a bit more specific.

        Thats correct. Using a formula via Macro, or not.

        pcnut

        "Wisdom is knowing what to do next, skill is knowing how to do it, and virtue is doing it."

                                                                                                                                David Starr Jordan

        S.C.'s weekly-indicative random pairs: 05, 12, 13, 16, 18, 23, 34

        Enjoy

        pcnut