http://www.excelforum.com/excel-form...ir-status.html
Same problem as the solved one above but MUST NOT use array formula.
1. WITHOUT using array formula
AND
2. ONLY using formula, no menu sort or macro options
ie. columnn A has list of numbers, some occur more than once.
output to two new columns listing each unique number and how often it occurs in first column.
This could instead be names instead of numbers.
If I use countifs or frequency i would still get duplicated counts.
Note: the list length may be a fixed/defined length. eg. Out of 12 values, count the unique values.
A B C
MARY MARY 3
JOHN JOHN 2
JOHN JOE 1
MARY
JOE
MARY
Bookmarks