New Excel Forum

This forum has been moved to

Ask all future questions in the New Excel Forum.


Logic for Serial Number

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Logic for Serial Number

Postby Shushant27 » Thu Dec 15, 2016 2:09 am


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
2 AB006
3 AB007
4 AB008

Can you suggest some trick.

  • 0

Posts: 1
Joined: Dec 15, 2016
Reputation: 0
Excel Version: Microsoft Excel 2010

Re: Logic for Serial Number

Postby gebobs » Mon Dec 19, 2016 12:44 pm

What do you mean by "counted"? Using the sample data provided, what exactly are you looking to do?
  • 0

Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010

Re: Logic for Serial Number

Postby Shashank » Thu Feb 09, 2017 10:54 pm

Dear Sir
please note the file enclosed, may be this is what you are looking at, in the given file the formula used is
this means
Col c: will have serial numbers
Col D: will have your AB001, etc etc
when D14 is equal to D13, the cell will display blank, if not it will add one to the largest number available above the cell in Col C
if this donot serve your purpose, you may write back here please
  • 0

You do not have the required permissions to view the files attached to this post.
Experience is what you get when you don’t get what you want.
Valued Contributor
Posts: 126
Joined: Jul 29, 2013
Location: India
Reputation: 10
Excel Version: 2007

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 6 guests