Formula for grouping duplicates and asigning to each groud number in colum

roulendz

New member
Joined
Dec 19, 2013
Messages
2
Reaction score
0
Points
0
Hello, everyone,

I am stuck!

I have excel file with product list.

The thing is, that I have duplicate titles.

And for these duplicate titles, I need to attach in next colum number, so they can be grouped and filtered by numbers also, not just titles.

In file, example of list, with all products.
In red colum is example.

link--> failiem [dot] lv/u/turrwqc
or

View attachment Precu nomenklatura for 1C Muk 2013-12-18 (macro).xlsm

The thing, is, that I want formula or VBA, what will give me those numbers automaticly

Example
Colum A | Colum B
Title | Group number
Bread 1
Coffey 2
Coffey 2
Drinks 3
Chocolate 4
Chicken 7
Pork 8
Beef 9
Beef 9
Beef 9
Beef 9
Salads 10
Juice 11

and etc.

Any help would be appreciated, thanks!
 
Last edited:

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

=IF(A2<>A1,MAX(B$1:B1)+1,B1)

copied down.
 
Top