bloubul
Member
PAB
Will you please help me again.
I'm looking for a macro to delete rows which contains 2 and more numbers from the previous draw. E.g.
Sheet1:
In columns A1 to F1 lies the 6 numbers from previous draw.
In columns H1 to M4000 lies my wheel.
In columns O1 to T4000 is my formula to tell me which rows in the wheel matches A1 to F1. (THe formula is the one that you did for me on 28 October 2005, repeating numbers).There are plenty of rows that contains 2 and more numbers of the previous draw, we know that it is very unlikely that more than 2 of the previous draws numbers will appear in the next draw. By deleting some rows the wheel will be more playable.
Thanks
BlouBul
Will you please help me again.
I'm looking for a macro to delete rows which contains 2 and more numbers from the previous draw. E.g.
Sheet1:
In columns A1 to F1 lies the 6 numbers from previous draw.
In columns H1 to M4000 lies my wheel.
In columns O1 to T4000 is my formula to tell me which rows in the wheel matches A1 to F1. (THe formula is the one that you did for me on 28 October 2005, repeating numbers).There are plenty of rows that contains 2 and more numbers of the previous draw, we know that it is very unlikely that more than 2 of the previous draws numbers will appear in the next draw. By deleting some rows the wheel will be more playable.
Thanks
BlouBul