hi experts
I want autonumber duplicates items .
what I have in column B
COST1
COST1
COST1
COST2
COST2
COST3
COST3
COST3
COST3
the result in column A should be
1 COST1
1 COST1
1 COST1
2 COST2
2 COST2
3 COST3
3 COST3
3 COST3
3 COST3
and if I delete or filter one of them shouldn't affect , just keeping the numbers
I want autonumber duplicates items .
what I have in column B
COST1
COST1
COST1
COST2
COST2
COST3
COST3
COST3
COST3
the result in column A should be
1 COST1
1 COST1
1 COST1
2 COST2
2 COST2
3 COST3
3 COST3
3 COST3
3 COST3
and if I delete or filter one of them shouldn't affect , just keeping the numbers