Welcome Guest
You last visited December 7, 2016, 4:45 am
All times shown are
Eastern Time (GMT-5:00)

# Can Excel do this?

Topic closed. 8 replies. Last post 10 years ago by sar30.

 Page 1 of 1

United States
Member #48158
December 12, 2006
32 Posts
Offline
 Posted: April 2, 2007, 7:12 am - IP Logged

Is there a function in excel to create pairs of numbers out a 3 didgit number? Example: 312  pairs would  be 31,12 and  32.

also can excel determine repeating numbers? example

312/ 3

358/ 5,8

582/ 2

299

If anyone knows the formula for excel to do this please share. Working on P3 sysytem. will share with  all if works.

Anywhere & Everywhere
United States
Member #10713
January 23, 2005
290 Posts
Offline
 Posted: April 2, 2007, 2:21 pm - IP Logged

Yes, excel can. is 312 in one cell or is each digit in individual cells?

United States
Member #48158
December 12, 2006
32 Posts
Offline
 Posted: April 2, 2007, 2:33 pm - IP Logged

312 would be one cell

New Jersey
United States
Member #17843
June 28, 2005
49725 Posts
Offline
 Posted: April 2, 2007, 2:57 pm - IP Logged

Their is no Function to create pairs, but you can create pairs by writing your own formulas. How much experience to you have using Excel?

A mind once stretched by a new idea never returns to its original dimensions!

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: April 2, 2007, 8:54 pm - IP Logged

let's say 312 is in cell A1

to get the front pair(31) put this in cell B1

=LEFT(A1,2)

to get the back pair(12) put this in cell C1

=RIGHT(A1,2)

to get the bookends(32) put this in cell D1

=CONCATENATE(LEFT(A1,1),RIGHT(A1,1))

I'm not so sure about the repeating numbers from a single cell without a vba macro of some sort. I'll start working on that one...

Playing more than one ticket per game is betting against yourself.

United States
Member #48158
December 12, 2006
32 Posts
Offline
 Posted: April 2, 2007, 11:37 pm - IP Logged

Thank you..

I will try that...

United States
Member #48158
December 12, 2006
32 Posts
Offline
 Posted: April 2, 2007, 11:47 pm - IP Logged

Worked perfect

Any way to count the number of the same pairs?

or same numbers

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: April 3, 2007, 5:39 am - IP Logged

to get a list count of all the pairs

in column e1 thru e100 enter 00 thru 99

(to get a leading zero, from the top menu go to format/cells/number/custom and enter 00)

let's assume you have 9000 numbers

in f1, enter

=countif(\$B\$1:\$D\$9000,E1)

then drag it down to f100

this will count ALL of the pairs without differentiation

if you want to count all pairs and determine front pair/back pair/bookends...

in f1 (for front pair)

=countif(\$B\$1:\$B\$9000,E1)

in g1 (for back pair)

=countif(\$C\$1:\$C\$9000,E1)

in h1 (for bookends)

=countif(\$D\$1:\$D\$9000,E1)

drag(autofill) these down to f100, g100 and h100, respectively

Playing more than one ticket per game is betting against yourself.

United States
Member #48158
December 12, 2006
32 Posts
Offline
 Posted: April 3, 2007, 7:23 am - IP Logged

I am not able to get this function to work: Here is my sample line starts at 2 and goes to 29 and want to count pairs in this range.

 D E F 06 62 02 71 13 73 58 82 52 52 26 56 97 78 98 88 85 85 23 31 21 02 26 06 34 40 30 85 54 84 92 22 92 38 84 34 52 27 57 64 47 67 36 68 38 47 70 40 22 28 28 15 54 14 42 20 40 05 57 07 86 65 85 24 44 24 12 27 17 26 67 27 18 86 16 02 28 08 05 55 05 12 26 16

 Page 1 of 1