K
KK
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!
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!