Welcome Guest
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
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

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

Huh?

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.

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

 Page 1 of 1