if column A has only randomly lets say 1 and 0 , how can i determine what is the closest pattern to put into column B. Is the pattern of 1 and 0, or every other or every 3, or some other pattern? Any formula that can go into a cell? Thanks