Hello,

I am trying to create an auto generating number column to populate if something is entered in Column D. Column D is a drop down menu, you can select option A, Option B or Option C. I want the number to go 1 to 10 for each option (30 rows all up).

This is kind of where I was heading with it, but it's not working

=+IF(D14=M9,MAX(A13:A51)+1,)+IF(D14=M10,MAX(A13:A51)+1,)+IF(D14=M11,MAX(A13:A51)+1,)
Thanks!