|Posted: July 27, 2005, 10:56 pm - IP Logged|
You only need to enter the the drawings in cell range C4 through E10. Most current goes in cell C4, D4, E4 (Position 1, Position 2, Position 3)
Once you have all the current drawings entered all you do is locate the control key on your keyboad "Ctrl". Press and hold down the "Ctrl" Key and at the same time press the "L" key if you want the Cell Range N4 through O14 sorted Low to High.
If you want to sort High to Low hold down the Ctrl (Control Key) and press the "H" Key. This will sort Cell Range N4 through O14, sorted High to Low.
You don'ta toucha the cell range N4 through O14. That's the reason for the Macro. All you have to do is use the control Ctrl Key and either the H or L (H = High to Low) (L=Low to High).
When you press Ctrl > L, look at cell range G20 through L29. These are your combinations based on Low to High.
When you press Ctrl > H, look at cell range G20 through L29, Thes are your combinations based on High to Low.
1. Look at cell range N4 through N14. This column represents digits.
2. Look at cell range O4 through O14. This column represents the number of times the corresponding digit in cell N has hit in the last 7 drawings.
Hope this helps!!