Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to number unique entry values in excel
Hello Lucien,
For the example you gave, it would be as simple as typing the formula: =COUNTIF(A$1:A2,A2) into cell C2 and copying down, since you only seem to be counting the number of occurrences (so far) of each type of fruit. If you need anything more complicated, you'll need to post again with an example that shows what else you need. Cheers -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of unique values in column | Excel Worksheet Functions | |||
Calculating the number of unique values with a range | Excel Discussion (Misc queries) | |||
How do I lookup the number of unique values from a list? | Excel Discussion (Misc queries) | |||
How do i count the number of unique values in a given column? | Excel Discussion (Misc queries) | |||
Count number of Unique values | Excel Worksheet Functions |