Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Is it possible to use an array formula on a range and have it report the unique values in that range and the number of times each was encountered? Barring an array formula solution (preferred) I would entertain a macro solution. Thanks, Norm XL2002 Windows2000 Eaxample: To get the unique entries in Col A and report then in Col B and the number of times for each in Col C. Col A Col B Col C 1 1 1 3 3 1 7 7 1 9 9 3 9 12 1 9 16 1 12 21 2 16 33 1 21 44 1 21 78 7 33 81 1 44 132 1 78 156 1 78 78 78 78 78 78 81 132 156 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unique values in an array. | Excel Discussion (Misc queries) | |||
i want to count how many times an entry occurs in an array | Excel Worksheet Functions | |||
Array formula for unique values | Excel Worksheet Functions | |||
Array formula for unique values | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions |