LinkBack URL
About LinkBacks
iantix 
In your example, try:
Cheers,
=SUMPRODUCT(1/COUNTIF(A2:A30,A2:A30))
In your example, try:
Cheers,=SUMPRODUCT(1/COUNTIF(A2:A30,A2:A30))
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
@sweep - I tried this one on my live data set;
Formula:
=SUMPRODUCT(--(FREQUENCY(MATCH(A2:INDEX(A:A,MATCH("zzzzz",A:A,1)),A2:INDEX(A:A,MATCH("zzzzz",A:A,1)),0),ROW(A2:INDEX(A:A,MATCH("zzzzz",A:A,1)))-ROW(A2)+1)>0))
And the sheet just hung while calculating (note - my live data, the emails are in column C but I did make all changes, to no avail).
OOI - what does the 'zzzzz' represent?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks