| 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 |
| 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 | |||
Threaded Mode
