Harry0 Member Jun 7, 2022 #1 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
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
nageswara rao New Member Jun 7, 2022 #2 The description is still not clear. Can you post sample workbook?