Forum Discussion
Problem creating an Excel formula
I am contacting you because I am having trouble creating a formula to count names in an Excel spreadsheet. I have created a schedule in Excel in which there is usually one name per cell. The calcula...
= LET(
list, TOCOL(Table1[names],1),
count, MAP(list, WORDCOUNTλ),
SUM(count)
)
where
WORDCOUNTλ = LAMBDA(item,
COUNTA(REGEXEXTRACT(item, "\w+", 1))
);