Forum Discussion
Dee1234910
Jun 30, 2023Copper Contributor
How many times a name appears.
Hi all, We often need to see how many times a name appears on some data (pulled at regular intervals) is there a formula that will create a list of the name that appear in column A. and how many...
OliverScheurich
Jul 01, 2023Gold Contributor
=HSTACK(UNIQUE(A1:A8),BYROW(UNIQUE(A1:A8),LAMBDA(x,COUNTIF(A1:A8,x))))
This is with Office 365 or Excel 2021.