Forum Discussion
Formula?
MargotKloeck Perhaps you can use the method demonstrated in the attached file.
Sheet1 contains a list of names in A and a lookup formula in B2 copied down a bit. The formula expands its lookup range as you copy it down. That's your starting position as if you would start from scratch.
I copied that list to Sheet2 to demonstrate the next step.
Name01 is new so the lookup formula doesn't find it in the rows above. Hence a "-". Now, just over-write the formula with the number for Name01. Do that for every name. The next time you enter Name01 in A, the formula in B will pick it up from the rows above it, and so on.
Just make sure that you always have at least one row with the formula in B, so that you can copy it down when the name list grows.
MargotKloeck Perhaps you can use the method demonstrated in the attached file.
Sheet1 contains a list of names in A and a lookup formula in B2 copied down a bit. The formula expands its lookup range as you copy it down. That's your starting position as if you would start from scratch.
I copied that list to Sheet2 to demonstrate the next step.
Name01 is new so the lookup formula doesn't find it in the rows above. Hence a "-". Now, just over-write the formula with the number for Name01. Do that for every name. The next time you enter Name01 in A, the formula in B will pick it up from the rows above it, and so on.
Just make sure that you always have at least one row with the formula in B, so that you can copy it down when the name list grows.