sequential numbering

[Guest]

I am hoping someone can help me with regards to an Excel formula.

I need the first column to have sequential numbering as it goes to the next
row, i.e. 1, 2, 3, 4, etc…The condition is as follows:
IF the 3rd column is blank, then the row in column 1 will increase by 1; IF
the 3rd column has “any†text/numbers (is populated), then the row in the
first column will remain blank until the 3rd column is once again blank and
at that point, it will once again increase in sequence, to the next
number…Does that make sense?

So far I have this: =IF(C17="","",1)
It works great for leaving a blank if there isn’t anything in the 3rd column
and it adds a 1, if there is something but I don’t know how to make it go
further than 1.

Thank you for your help!

 

[Ragdyer]

Your sample formula will increment Column A when Column C is *NOT* blank.

However, your text explanation is the *OPPOSITE*, saying you want to
increment Column A when Column C *IS* blank ! ? ! ?

Assuming your formula is what you want, try this in Column A:

=IF(C1="","",COUNTIF($C$1:C1,"<>"))

And copy down as needed.

 

[T. Valko]

If I understand, try this in A17 and copy down as needed:

=IF(C17="",COUNTBLANK(C$17:C17),"")

Biff

 

[Guest]

Thank you Ragdyer for time and input...You had the closest answer but I still
need more info...

=IF(C17="","",COUNTIF($C$1:C1,"<>")) This one leaves a blank when column 3
is blank, this is correct – When I populate column 3, a 0 is always entered –
I need it go in sequence i.e. 1, then 2, then 3 etc…

 

[Ragdyer]

In Column C, when I manually key in a number, or text, the number in Column
A increments ... starting at 1.
A C
1 _ _
2 1 QQ
3 _ _
4 _ _
5 2 25
6 3 RED
7 _ _
8 etc...

What exactly do *you* have in Column C?

 

[Guest]

When I manually enter any number or text in column C, column A puts only 0's
and never increments to a higher integer, but it does leave it blank when c
is blank, that part works well.
A B C
1 0 9
2 - -
3 - -
4 0 5

 

[Ragdyer]

My formula was meant to start in A1, meaning it was polling Column C,
starting in Row1.

If you're *starting* in Row17, you should use something like this:

=IF(C17="","",COUNTIF($C$17:C17,"<>"))

 

[Guest]

Hey Ragdyer...I figured out why it didn't increment!!!...YAY!!!...Oh HAPPY
DAYS!!!
Thank you so MUCH for your input!!!...I couldn't have done it without you!!
)

Here are my changes to make it work:
=IF(C17="","",COUNTIF(C$17:C17,"<>"))

Here is your original:
=IF(C1="","",COUNTIF($C$1:C1,"<>"))

A couple of changes here and there, and viola!! IT WORKS!!!! I am SO
HAPPY!!!!

Thank you so VERY MUCH!!

 

[Ragdyer]

It seems our last posts crossed, where I recommended the solution you
figured out yourself.

Thanks for the feed-back.