Quote:
Originally Posted by Sgt Rock
To clarify, you prefer to solve via Excel and not VBA - correct?
|
Correct. But a VBA solution would be acceptable if nothing else presents itself. This would be a breeze in Access, but Access seems to have run its course.
Quote:
Originally Posted by Catalin.B
The formula used in the attached file is:=SUM(IF(FREQUENCY(IF($A$2:$A$27&$C$2:$C$27=A20& C20,MATCH($B$2:$B$27,$B$2:$B$27,0)),IF($A$2:$A$27& $C$2:$C$27=A20&C20,MATCH($B$2:$B$27,$B$2:$B$27,0)) )>0,1))
|
Thanks. Very nice. But is there a way to just have formula in the Metrics tab? That would be preferable. The Log tab data will be imported from a database generated CSV and may be tens of thousands of lines long. If not, this may work.
Quote:
|
There is a typo error in Log sheet, Type column in cell B21, Yellow value has a trailing space, that is wrongly identifying this row as unique. I recommend using data validation lists, to avoid errors like this.
|
This was just dummy data I drummed up for the example. As above, that data will be database generated.
10-13-2014, 05:31 AM
Similar Threads
formula taking long time to distinct word
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode