Originally Posted by daddylonglegs You could also use this one to avoid CSE...... =SUMPRODUCT((A1:A50<>"")/COUNTIF(A1:A50,A1:A50&"")*(COUNTIF(A1:A50,A1:A50)>=3)) Something about that formula looked awfully familiar... so I checked my "formula stash" and there it was!. What's the point in have a stash if I don't even use it? (sheesh) I'm glad YOU were on the ball! (I sure wasn't)
Ron Former Microsoft MVP - Excel (2006 - 2015) Click here to see the Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks