Welcome Guest

NetConnect

Internet Domains, simple and cheap

Find a domain name:

Home

The time is now 5:36 pm
You last visited December 5, 2013, 5:35 pm
All times shown are
Eastern Time (GMT-5:00)

Need some Excel help

Topic closed. 1 reply. Last post 1 year ago by SergeM.

 Page 1 of 1
Member #19992
August 9, 2005
2797 Posts
Offline
 Posted: June 10, 2012, 7:16 pm - IP Logged

I need your expertise excel help...

Can you create a spreadsheet that can do the following...

01x 05x 07x 08x

21x 25x 27x 28x

61x 65x 67x 68x

81x 85x 87x 88x

x10 x13 x17 x18

x50 x53 x57 x58

x70 x73 x77 x78

x80 x83 x87 x88

0x0 0x3 0x7 0x8

2x0 2x3 2x7 2x8

6x0 6x3 6x7 6x8

8x0 8x3 8x7 8x8

For each of the sets above I have certain pairs I want to impliment into these sets, but only want them forming numbers if it already has one of the numbers in the pairs within it.  For example above we have 8x0 8x3 8x7 8x8.... if I have the pairs 19, 01, 05 and 15 I want it to only produce sets of straight numbers that the pair would join in...so since pair 8x0 has the 0 in it, it would make 810 from pair 01 and also make set 850 from pair 05... and so on for all the other sets.

Is this something that can be done?  Thanks.

We are all Lucky... just some of us don't realize it!

Station C:\somewhere\in\space\time
Fiji
Member #123705
February 27, 2012
2188 Posts
Offline
 Posted: June 11, 2012, 6:49 am - IP Logged

B1: '="01"&$A$1', but if you need to filter then B1 '=0', C1 '=1', D1 '=$A$1', next row.

If you want to add combinations then you better put all thousand combinations in the cells and filter out what you want to play.

.

 Page 1 of 1