Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count duplicates in an array?
I am using Office 2003 on Windows XP.
I need to be able to count the number of each item in a single element array, then write out the counts. For example, if the array contains: Red, Blue, Red, Orange, Orange, Red, Green, Blue My result would be: A1: Red B1: 3 A2: Blue B2: 2 A3: Orange B3: 2 A4: Green B4: 1 If anyone has a function to which I could pass my array to output the counts or could share some code I could adapt it would be most appreciated. Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with An Array Formula and Duplicates | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
array formula with duplicates | Excel Discussion (Misc queries) | |||
No duplicates from range to an array | Excel Programming | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions |