Forum Discussion
Beginner Help in getting Summary - Distinct Name & No. of times used in Specific data range
Trying to make a small project. I was able to get Distinct Values (B25:B29), but not able to get the number of times (Count) matching the values. Need help.
= LET(
distinctLine, SORT(UNIQUE(Line)),
count, COUNTIFS(Line, distinctLine),
HSTACK(distinctLine, count)
)