Incrementing amounts when text is used

B

blairake

Is there a way to have the cells increment a number if there is text in the
string. Lets say I put [email protected] in cell A1, and I want to show
[email protected] in cell. Is there a formula that will increment the numbers?
I know the fill handle won't do it.
 
B

blairake

I typed in the formula as shown but it didn't work. I put a 1 between the
first set of parenthesis, and 100 between the second set. When I hit enter I
goit the error saying there was a problem with the formula, but it didn't
offer a fix.
 
G

Gary''s Student

You don't need to put in the 1. The ROW() function will supply that if the
formula is in column A
 
Top