karthick87
Member
Hi Team,
How do I count the same numbers. For example please look at the attachment, the column "value1" will be having different values (any numbers). In value2 I just want to have the count in all the cells (ie, if I have 10 tens in value1 then it has to put the values from 1 to 10 in values2). Likewise if the values changes in value1 then it has to start the counting from 1. How do I write a formula for this? Can anybody help me pls. Thanks in advance.
How do I count the same numbers. For example please look at the attachment, the column "value1" will be having different values (any numbers). In value2 I just want to have the count in all the cells (ie, if I have 10 tens in value1 then it has to put the values from 1 to 10 in values2). Likewise if the values changes in value1 then it has to start the counting from 1. How do I write a formula for this? Can anybody help me pls. Thanks in advance.