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!
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: