Unique entries for average

[dmacmillan]

Hi,

Can SUMIFS, COUNTIFS, AVERAGEIFS be used to isolate unique entries? The problem is SUMPRODUCT(1/COUNT(A:A,A:A)), for example, is very slow on 5 conditions and 10,000 plus lines. I have hit a road block after trolling the net for hours.

Thanks in advance,
David

 

[Matty]

The formula I posted here...

http://www.mrexcel.com/forum/showthread.php?t=560971

...is, as I understand it, the fastest method, but this will still be slow given the size of your data set and the number of conditions being applied.

Matty

 

[Aladin Akyurek]

See also post #7 in:

http://www.mrexcel.com/forum/showthread.php?t=480461

for using SQL.

 

[dmacmillan]

Thanks Matty and Aladin, your posts are shaping my formula nicely. Still have a couple of queries that I will pick up in another Thread (with the same Title).

Regards,
David