Perhaps this will help...

Sheet1

A B C 1 Bob 4 2 Ted 3 Carol 4 Alice 5 Ted 6 Bob 7 Carol 8 Ted 9 Carol 10 Ted Excel 2007

Array Formulas

Cell Formula C1 =SUM(1/COUNTIF(A1:A10,A1:A10)) Entered with Ctrl+Shift+Enter.If entered correctly, Excel will surround with curly braces {}.Note: Do not try and enter these manually yourself

## Like this thread? Share it with others