Can anyone help me with Excel?

Reply #10

Sage — Tue, 30 Mar 2010 02:07:51 GMT

Thank you everyone it works perfect Carbob was correct! Love you guys at ther Lottery Post! Thank YOU

Reply #9

winsumloosesum — Sat, 27 Mar 2010 12:45:30 GMT

Try this. Excel 2002

http://www.box.net/shared/ibcqxb36us

Enter your 5 digits in column a and drag down the formula(s) in column b

Reply #8

sysp34 — Sat, 27 Mar 2010 12:44:28 GMT

the vb code work perfectly, just use Carbob description and tada... :) we got like this

A B

1 0 123456789

2 01 23456789

3 012 3456789

4 0123 456789

5 01234 56789

6 012345 678

7 0123456 789

8 01234567 89

9 012345678 9

10 0123456789

Spreadsheet Formulas

Cell Formula

B1 =aconcat(IF(ISERR(SEARCH({0,1,2,3,4,5,6,7,8,9},A1)),{0,1,2,3,4,5,6,7,8,9}, ))

B2 =aconcat(IF(ISERR(SEARCH({0,1,2,3,4,5,6,7,8,9},A2)),{0,1,2,3,4... [ More ]

Reply #7

CARBOB — Sat, 27 Mar 2010 10:33:53 GMT

Read very carefully, any questions, ask.

Open a new workbook.

Step 1

Add this fucntion to VB (alt F11) Insert Module

Copy and paste the macro, in red into module. exit VB.

Function aconcat(a As Variant, Optional sep As String = ) As String

' Harlan Grove, Mar 2002

Dim y As Variant

If TypeOf a Is Range Then

For Each y In a.Cells

aconcat = aconcat y.Value sep

Next y

ElseIf IsArray(a) Then

For Each y In a

aconcat = aconcat y sep

Next y

Else

acon... [ More ]

Reply #6

Sage — Sat, 27 Mar 2010 05:36:43 GMT

Thanks Carbob. I'm not sure. Maybe it's something I'm doing wrong on my part. Can you help me

Reply #5

CARBOB — Fri, 26 Mar 2010 09:35:54 GMT

What type of message did you get, don't just say, for some reason that didn't work? It works if done right. Did you enter the 6 digits in A1? Did you enter the formula in B1? Did you name the formula in B1, in Name Manager, Digits works just fine.

Reply #4

Sage — Fri, 26 Mar 2010 08:08:38 GMT

Thanks for some reason that didn't work

Reply #3

lotteryprophet — Wed, 24 Mar 2010 15:07:30 GMT

fibonacci had similar question and posted an answer I believe.

https://www.lotterypost.com/thread/209623

Reply #2

Sage — Wed, 24 Mar 2010 01:50:58 GMT

Wow that's why I love this place! I'm going to see if it works! Thank you for posting and caring! If I can do anything for you just let me know. If I can I will believe me

Reply #1

Raven62 — Tue, 23 Mar 2010 19:40:01 GMT

https://www.lotterypost.com/thread/209623/1571102

Lottery Post Forums Search is Your Friend!

https://www.lotterypost.com/search?q=excel+missing+digits t=all

Can anyone help me with Excel?

Sage — Tue, 23 Mar 2010 19:19:33 GMT

I'm trying to figure this out. Let's

say I have the digits 1 2 3 4 5 and I want to know what digits are missing =0 6 7 8 9

How can I program this in Excel? Do I need and XL formula or macros? Can somebody write me the formula so I can just put it into my spreadsheet?

Please help! Thank you