My excel doesn't autofill even when i drag down, it only repeats the values, i have used the flash fill but the best i get is a linear series counting from the value directly above. it can't continue a series of even numbers. i use an excel 2016 (professional plus) but an excel 2007 proved the same, on videos i watch their excel was able to autofill first names from full name, not the case for mine, please assist me!
Solved by M. C. in 16 mins