Can Excel do this?

Reply #8

sar30 — Tue, 03 Apr 2007 11:23:21 GMT

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

Reply #7

hypersoniq — Tue, 03 Apr 2007 09:39:09 GMT

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... [ More ]

Reply #6

sar30 — Tue, 03 Apr 2007 03:47:28 GMT

Worked perfect

Any way to count the number of the same pairs?

or same numbers

Reply #5

sar30 — Tue, 03 Apr 2007 03:37:42 GMT

Thank you..

I will try that...

Reply #4

hypersoniq — Tue, 03 Apr 2007 00:54:54 GMT

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...

Reply #3

Raven62 — Mon, 02 Apr 2007 18:57:41 GMT

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

Reply #2

sar30 — Mon, 02 Apr 2007 18:33:03 GMT

312 would be one cell

Reply #1

WSN1 — Mon, 02 Apr 2007 18:21:18 GMT

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

Can Excel do this?

sar30 — Mon, 02 Apr 2007 11:12:02 GMT

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.