Looking for Excel Formula or Function That Counts Characters in a Text String

Reply #13

Raven62 — Mon, 19 Nov 2018 20:27:56 GMT

AAAA 10

AAAB 45

AABB 45

AABC 120

ABBB 45

ABBC 120

ABCC 120

ABCD 210

Total 715

Reply #12

Raven62 — Mon, 19 Nov 2018 20:09:48 GMT

.#. ABCD ARR1 - ARR1 ABCD

001 0000 AAAA - AAAA 0000

002 0001 AAAB - AAAA 1111

003 0002 AAAB - AAAA 2222

004 0003 AAAB - AAAA 3333

005 0004 AAAB - AAAA 4444

006 0005 AAAB - AAAA 5555

007 0006 AAAB - AAAA 6666

008 0007 AAAB - AAAA 7777

009 0008 AAAB - AAAA 8888

010 0009 AAAB - AAAA 9999

011 0011 AABB - AAAB 0001

012 0012 AABC - AAAB 0002

013 0013 AABC - AAAB 0003

014 0014 AABC - AAAB 0004

015 0015 AABC - AAAB 0005

016 0016 AABC - AAAB 0006

017 001... [ More ]

Reply #11

JADELottery — Mon, 19 Nov 2018 15:37:37 GMT

Made a little Excel sheet for ya.

https://members.lotterypost.com/jadelottery/images/Pick4BoxedSets-01.zip

It has two sheet in it.

One shows all Pick 4 combos from 0000 to 9999, and the other has some with random Pick 4 combos.

See here is:

Sheet1

Sheet2

Reply #10

Raven62 — Sun, 18 Nov 2018 20:33:24 GMT

Cells G2 thru J2: P4 Boxed

Cell K2: =COUNTIF($G2:$J2,SMALL($G2:$J2,1)) COUNTIF($G2:$J2,SMALL($G2:$J2,2)) COUNTIF($G2:$J2,SMALL($G2:$J2,3)) COUNTIF($G2:$J2,SMALL($G2:$J2,4))

Cell L2: =IF($K2= 1111 , ABCD ,IF($K2= 2211 , AABC ,IF($K2= 1221 , ABBC ,IF($K2= 1122 , ABCC ,IF($K2= 2222 , AABB ,IF($K2= 3331 , AAAB ,IF($K2= 1333 , ABBB ,IF($K2= 4444 , AAAA ,

Reply #9

JADELottery — Sun, 18 Nov 2018 14:00:38 GMT

yep, thought about that subset.

would be a little more, but we can look in to it.

Reply #8

JADELottery — Sun, 18 Nov 2018 04:01:37 GMT

Glad to help.

Good Luck.

Reply #7

AllenB — Sat, 17 Nov 2018 20:50:49 GMT

Thank You. That is Exactly what I Needed.

Much more direct than my approach.

You are the Master, Sir.

Reply #6

Raven62 — Sat, 17 Nov 2018 18:32:07 GMT

ABBC, ABCC, ABBB

Reply #5

JADELottery — Sat, 17 Nov 2018 17:06:20 GMT

Actually you can get it down to a set of {0, 1, 2, 3, 4}.

Where each of the numbers in the set are as follows:

0 - A B C D (1 2 3 4)

1 - A A B C (1 1 2 3)

2 - A A B B (1 1 2 2)

3 - A A A B (1 1 1 2)

4 - A A A A (1 1 1 1)

If the individual numbers are in the cells A1, B1, C1 and D1; with the formula in cell E1, then the single formula in E1 would be:

=LOOKUP((A1=B1)+(A1=C1)+(A1=D1)+(B1=C1)+(B1=D1)+(C1=D1),{0,1,2,3,6},{0,1,2,3,4})

Excel translates the equals compari... [ More ]

Reply #4

AllenB — Sat, 17 Nov 2018 16:21:50 GMT

1234 1 2 3 4 11

1223 1 2 2 3 12 or 21

1122 1 1 2 2 22

1113 1 1 1 3 31 or 33

Now I am done

Reply #3

AllenB — Sat, 17 Nov 2018 14:39:32 GMT

=COUNTIF(E12:H12,SMALL(E12:H12,2)) COUNTIF(E12:H12,SMALL(E12:H12,4))

1234 1 2 3 4 11

1223 1 2 2 3 21

1122 1 1 2 2 22

1113 1 1 1 3 31

This is where I am. I guess I answered my question. Hope this helped someone.

Reply #2

Raven62 — Sat, 17 Nov 2018 14:36:23 GMT

LP's Inspect 4 Number Set Analysis:

Number Type tabulates the type of the combination, among the five different types: A-B-C-D, A-A-B-C, A-A-B-B, A-A-A-B, and A-A-A-A.

Reply #1

AllenB — Sat, 17 Nov 2018 14:00:43 GMT

I Found This. It requires that the Digits be in Columns. This is almost It but it Does not identify a Double Double (2244) result is 2.

=CHOOSE(MAX(INDEX(COUNTIF(E13:H13,E13:H13),)), 1 , 2 , 3 , 4 )*1

I will live with the columns if I can Identify a Double double by expanding the Formula Above.

What I Really hope is possible is getting the answer form 1 Cell only.

Am I Dreaming

Looking for Excel Formula or Function That Counts Characters in a Text String

AllenB — Sat, 17 Nov 2018 13:32:37 GMT

The Goal is to Identify the Type of Box in a Pick 4 Draw without having to form a Giant Table. I am hoping that Excel has a function that this does without the Need for a Very Long formula using Counts and Positions.

Thanks