Why am I getting number repeats in a row from macro

I am not getting any numbers that repeat in a row. However, I am getting many instances of numbers that repeat in the same column in adjacent rows (i.e., C4 and C5 have the same number). In one run I got 23 such occurrences. That is out of a total of 594 pairs of numbers, or an occurrence of 3.9%.

Your default is to generate an even or odd number in the range 1-53, which is 26 possible even numbers or 27 possible odd numbers. Let's take odd numbers. There are 729 possible combinations of two odd numbers in that range. Of those combinations, 27 of them are duplicates. That is a rate of 3.7%.

In other words, what you are seeing is exactly what is predicted by probability. To reduce the number of duplicates, use a higher upper limit.