Need help with an XL formula excell
https://www.lotterypost.com/thread/207340
Lottery Post Forum Topic: Need help with an XL formula excellen-usLottery Post RSS GeneratorReply #2
https://www.lotterypost.com/thread/207340/1526952
https://www.lotterypost.com/thread/207340/1526952Fri, 22 Jan 2010 01:14:30 GMTSageSageReply #1
https://www.lotterypost.com/thread/207340/1525754
https://www.lotterypost.com/thread/207340/1525754Thu, 21 Jan 2010 02:00:12 GMTphileight 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,]]>phileightNeed help with an XL formula excell
https://www.lotterypost.com/thread/207340
https://www.lotterypost.com/thread/207340Wed, 20 Jan 2010 07:10:36 GMTSage 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]]>Sage