
Originally Posted by
benishiryo
welcome to the forum, jeremysayshi. the easiest way is to do a Pivot Table. select the data, go to Insert -> PivotTable -> OK. put names in Row Labels & Names again in Values. if you don't want the Grand Total, right-click on it & Remove Grand Total.
if you want formulas, then try this array formula to get unique names in say G2 onwards:
=IFERROR(INDEX($A$2:$A$10,MATCH(0,COUNTIF(G$1:G1,$A$2:$A$10),0))&"","")
copy down as many cells as you need. then in H2, use a simple COUNTIF:
=COUNTIF(A:A,G2)
Bookmarks