View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lucien loyens lucien loyens is offline
external usenet poster
 
Posts: 1
Default How to number unique entry values in excel

Can anyone tell me if there is a formula or code that will give me a
numbering for every unique entry in a column(Product):
Product Shop Numbering
apple grocer1 1
apple grocer2 2
pear grocer3 1
cherry grocer4 1
pear grocer1 2
pear grocer5 3
apple grocer6 3

The numbering column should be code or a formula.
Grocer5 is the number 3 that has pear in column A(Products)
Column C(Numbering) should automatically recognise this with formula
or code

Thanks

Lucien Loyens