Numbering column with IF function

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

Please Login or Register  to view this content.

Thanks!

Hi Cchoma
Is this the sort of thing you mean? I put none in the value if false.

Please Login or Register  to view this content.

Thanks PhilB1 - it only stays as 'none' though, it doesnt seem to be adding +1 to numbers - do you suggest anything else?

Ford - if function goes M9, M10 and M10 in the formulas

I was attempting to get it to number Option A 1 to 10, same for Option B and Option C. They will not be directly underneath each other in the rows however.
It could be like:
Option A
Option B
Option A
Option C
Option A

in which case I wanted it to automatically number itself like
1 Option A
1 Option B
2 Option A
1 Option C
3 Option A
etc

Is this do-able?

Wowee that was easy haha, thank you!