In column A I want to auto populate a series of ID numbers in ascending order. I only want this to happen if a text value is present in the corresponding row in column B.
For example:
If B1 contains text, enter 1 in A1
If B4 contains text, enter 2 in A4
If B8 contains text, enter 3 in A8 .... And so on
Each consecutive row in column B will not have a value which means not every cell in column A should be populated
For example
If cells B1, B4, B8, B15 all contain text, I only want to auto populate Cells A1, A4, A8, A15 with the values 1,2,3,4
I have tried writing the following formula in cell A1:
=If(B1=””,””,1)
This works for cell A1 but if I drag the formula down, all cells in column A which have a corresponding text value in column B display the number 1.
How can I amend this formula to reference the value previously entered in cell A(x) and increment it by 1 each time?
Many Thanks
Bookmarks