# Numbering column with IF function

1. ## 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!

2. ## Re: Numbering column with IF function

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.``

3. ## Re: Numbering column with IF function

What am I missing here, all those formulas are the same?
Formula:
`Please Login or Register  to view this content.`

4. ## Re: Numbering column with IF function

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

5. ## Re: Numbering column with IF function

Originally Posted by Cchoma
Ford - if function goes M9, M10 and M10 in the formulas
Yes, I get that part, but no matter which 1 is selected, the "do this" part is the same.

How do you want the numbering to look, and based on what?

6. ## Re: Numbering column with IF function

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?

7. ## Re: Numbering column with IF function

Perhaps this is what you want?

 A B 2 1 Option A 3 1 Option B 4 2 Option A 5 1 Option C 6 3 Option A

A2=COUNTIF(\$B\$2:B2,B2)
copied down

8. ## Re: Numbering column with IF function

Wowee that was easy haha, thank you!

9. ## Re: Numbering column with IF function

Thanks

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

There are currently 1 users browsing this thread. (0 members and 1 guests)