In E1: =A1
E2: =IF(ISERROR(MATCH(0,COUNTIF(E$1:E1,$A$1:$A$20&""), 0)),"",
INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(E$1:E1,$A$1:$A$2
0&""),0)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Copy E2 down as far as you might need, max E25

F1: =IF(E1="","",AVERAGE(IF(A1:A25=E1,B1:B25)))

also an array formula. Copy this down to the same row as in E.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Hicoda" wrote in message
...
I have a list of twenty five names. This list contains data from 1 month.
Each name has multipule occurances. I need to create a list of unique
names
with the average of each individules data.