Hi!
I Have another thread from earlier and I am working on trying to expand a formula which was created from help in this forum http://www.excelforum.com/showthread.php?t=538999
So i'm now hoping for the same great help as I got the last time.
So I have this formula:
=COUNT(1/FREQUENCY(IF((LEFT(TOTUNDERLAG!H2:H4000;3)="#WO");IF(TOTUNDERLAG!T2:T4000="ABD";IF(TOTUNDERLAG!A2:A4000<>"";TOTUNDERLAG!A2:A4000)));IF((LEFT(TOTUNDERLAG!H2:H4000;3)="#WO");IF(TOTUNDERLAG!T2:T4000="ABD";IF(TOTUNDERLAG!A2:A4000<>"";TOTUNDERLAG!A2:A4000)))))
Where it should count th unique numbers in Column A if it meets the condition LEFT(#WO) in column H. But I want to add an AND condition to the first IF statement. like this:
=COUNT(1/FREQUENCY(IF(AND(LEFT(TOTUNDERLAG!H2:H4000;3)="#WO";RIGHT(TOTUNDERLAG!V2:V4000;4)="#FRO");IF(TOTUNDERLAG!T2:T4000="ABD";IF(TOTUNDERLAG!A2:A4000<>"";TOTUNDERLAG!A2:A4000)));IF(AND(LEFT(TOTUNDERLAG!H2:H4000;3)="#WO";RIGHT(TOTUNDERLAG!V2:V4000;4)="#FRO");IF(TOTUNDERLAG!T2:T4000="ABD";IF(TOTUNDERLAG!A2:A4000<>"";TOTUNDERLAG!A2:A4000)))))
But then again as the last time I started the last thread the formula returns 0. I have tried to play around with the number of ( ) but it doesn't matter.
Please help.
for the help these are the columns it should look for:
Column A
> PROBLEM_ID
> 1499986
> 1499986
> 1499986
> 1499986
> 1758434
> 1929352
> 1929352
> 1936837
> 1936837
Column V
GROUP_ID
ETD-I-SEDCSFRO
ETD-I-SEDCSFRO
ETD-I-SEDCSQA
ETD-I-SEDCSFRO
ABD-SEOSSFROQA
ABD-SEOSSFROQA
ABD-SEOSSINFFRO
ETD-I-SEDCSFRO
ABD-SEOSSINFFRO
Column H
ACTIVITY_ACTION_ID
#STATUS
#WORKING
#STATUS
#STATUS
#WORKING
#STATUS
#WORKING
#STATUS
#WORKING
This together should give the result 2 when also Column T is ABD.
But it returns 0 for a reason I can't seem to manage on my own.
thanks for the help?
Bookmarks