Hello,
I am working on excel.
I want Sr. No. to be counted if the cell in next column is not same as the cell above it.
Example of it as below:- Can you help me generate this.
[list=][/list]Sr. No. Code
1 AB005
AB005
2 AB006
3 AB007
AB007
4 AB008
Can you suggest some trick.
Shushant