https://www.lotterypost.com/thread/80047 Lottery Post Forum Topic: Need Help with Excel please en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/80047/168144 https://www.lotterypost.com/thread/80047/168144 Tue, 20 Jan 2004 03:54:59 GMT vick off the top of my head i would do this for each row of 5 digits, [replace the lookup_array with your 5 coloum row then copy this formula on down the rows of numbers] you can replace the 11, 22 32 by making them look at cell value that you can change to any numbers if you want=if(and(iserror(MATCH( 11, lookup_array, 0)),iserror(MATCH(22, lookup_array, 0)),iserror(MATCH(32, lookup_array, 0))),1,0)now when ever none of all three of those numbers are in that row of 5 numbers a 1 will be shown, oth... [ More ]

]]> vick https://www.lotterypost.com/thread/80047 https://www.lotterypost.com/thread/80047 Tue, 20 Jan 2004 03:21:06 GMT hypersoniq interesting puzzle... I have tried so far using the autofilter and advanced filter with no success. If I find anything that works I will pass it on.when I get stuck with excel, I sometimes go here to look for examples that may help... http://www.xl-logic.com/menu.html

]]> hypersoniq