New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

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

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

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

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

gebobs
Regular
 
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
=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: No registered users and 2 guests