vba excel expert

Table tang This table is a frequency of numbers 1 to 49 1. Find the mean value in tan table . Not the average . We are looking for the most frequent number appearing. 2. The fist target is find the mean value of the frequency for each number 1 to 49 according to the tan table ! Table : Number tang , explain This is a table of the same number where off number1 is the spot the number was drawn . The target is to adjust this table according the mean value in the frequency ascending downward .this means the for example the mean frequency is 15 the row it will go 14 numbers down . I have color marked the last 5 draw numbers and adjusted the table accordingly manually ( maybe not correct ) it is possible that according to the new draw numbers Finally the table need to fine tuned ,that means one or two pos up or down to match the last numbers . ( Results from last drawing ) The cos table: This is a reference chart from my old program . This is for ref. only The steg table: This is the number position of the draws numbers . The new table for cos : This is the result of your work what is coming out from the number tang table. After we move all the Rows for the correct position you need to transfer the new frequeny to the cos table. Finally we are looking for a correlation of the two table in order get the next possible drawing number in the steg table . Please let me know if you can do some code work for this . no one has done it before . it is simple excel work no rocket science Task [login to view URL] the mean value in tan table 2. Adjust by copy or by code the tan number table for the mean value in the frequency in position down 3. Find the new frequency and transfer into cos table. 4. Find the correlation of the new cos table and the tan table .