Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unique occurrences of a value Q
I have a number of locations listed in Column A. These are duplicated a
number of times. These are also variable (from a list of approx 60 possible locations) How can I add the instances of the unique locations listed For example, Column in could contain the following: London; Bristol; London (again); Bath; Manchester; Bristol; Liverpool etc I want to return (based on the above) London =2 Bristol = 1 Bath = 1 etc etc I don't want to use the formula if=London etc etc as I have a list of over 60 locations Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
how do i find unique avg buy prices in multiple group of buys/sell | Excel Worksheet Functions | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
Count unique occurrences of name | Excel Discussion (Misc queries) |