I am having trouble with the SUMPRODUCT/COUNTIF Formula being very slow, and constantly crashing my PC. I was wondering if you could please point me at an alternative formula to the attached.
=SUMPRODUCT(--(E2:E10<>"");1/COUNTIF(E2:E10;E2:E10&""))
Blue area
CONCATENATE range will be a minimum of 20,000 lines.
Yellow area
The intended result
ExcelTip.xlsx
Bookmarks