Hi, Guys, I have the following data (an example is shown here to explain/use for test) the actual data is in over 4000 rows & growing
43 53 39 40 63 43 12 44
44 59 49 55 41 35 40 59
44 59 48 47 41 43 63 46
37 48 52 47 45 63 41 44
41 37 53 51 35 55 48 41
41 37 53 51 35 55 48 50
41 37 53 51 35 55 48 43
46 44 47 51 41 49 45 50
50 47 42 36 50 38 25 47
41 47 48 44 53 47 37 37
50 55 52 51 63 43 45 47
41 43 47 47 50 49 45 43
47 37 55 36 55 63 41 48
59 37 43 49 48 51 45 51
41 39 48 45 63 49 52 55
41 50 51 48 45 55 57 48
47 43 47 47 38 49 37 44
I want to find out if there is any pattern in between rows any sequence of numbers is being repeated after some specific no of rows, this data requires the only comparative analysis in between rows and not Column,
your help will be highly appreciated Please do note I have some programming background no excel experience or VBA syntax knowledge would appreciate a slight explanation of the coding with an idea how to implement it
thanks in Advance
Mobi
Bookmarks