# Premium Excel Course Now Available!

## 45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!

## Logic for Serial Number

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

### Logic for Serial Number

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
• 0

Shushant27
Rookie

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

### Re: Logic for Serial Number

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

gebobs
Regular

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

### Re: Logic for Serial Number

Dear Sir
please note the file enclosed, may be this is what you are looking at, in the given file the formula used is
=IF(D14=D13,"",MAX(\$C\$3:\$C13)+1)
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
Regards
shashank
• 0

You do not have the required permissions to view the files attached to this post.
[b][color=#400040]Shashank[/color][/b]
Experience is what you get when you donâ€™t get what you want.
Shashank
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: Baidu [Spider], Google [Bot] and 3 guests