Need help with an XL formula excell

Reply #2

Sage — Fri, 22 Jan 2010 01:14:30 GMT

Wow thank you so much! I can't thank you enough. Happy New Years to you. There is no place like Lotery Post.

Reply #1

phileight — Thu, 21 Jan 2010 02:00:12 GMT

Sage

if you use VBA this will do it

Sub find_missing()

Dim md(10) ' set an array with 10 elements or positions

For x = 1 To 5 ' if your data is not in col a-e change these #'s

a = Cells(1, x): md(a) = 1 ' if row1,col1 =5 then md(5)=1 i'll use this later

Next x ' completes the loop each array element that matches one of your numbers now equalls 1

z = 6: For y = 0 To 9 'this loop will put the missing numbers in row1 col6-10

If md(y) = 1 Then GoTo skip Else Cells(1,... [ More ]

Need help with an XL formula excell

Sage — Wed, 20 Jan 2010 07:10:36 GMT

Could you help me?

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

Can you tell me how to do this in xl formula? I want to put this in a spreadsheet. Thanks