In article ,
EPMMGR06 wrote:
rTrying to count unique data in a column that contains mixed numbers & text.
Have a Sum(If(Frequency(Match) formula but I must have copied it wrong. What
is the corect formula for this?
Try...
=SUM(IF(FREQUENCY(IF(A2:A10<"",MATCH("~"&A2:A10,A 2:A10&"",0)),ROW(A2:A10
)-ROW(A2)+1),1))
....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions