Supermike1983
New Member
- Joined
- Oct 4, 2016
- Messages
- 15
I have a frequency problem I don't seem to find a solution for. Below you find an extract of just the columns I want to compare.
I want to write a frequency condition saying: "How many values in Column C does only include D values in Column G and FALSE in Column L?".
In this small example below the correct answer is 1 time.
<tbody>
</tbody>
The closest I get is this array formula:
{=SUM(IF(FREQUENCY(IF($C$2:Report!$C$10<>"";IF($L$2:$L$10="FALSE";IF($G$2:$G$10="D";MATCH("~"&$C$2:$C$10;$C$2:$C$10&"";0))));ROW($C$2:$C$10)-ROW($C$2)+1);1))}
Desperately need help!
I want to write a frequency condition saying: "How many values in Column C does only include D values in Column G and FALSE in Column L?".
In this small example below the correct answer is 1 time.
Column C | Column G | Column L |
6548923 | A | FALSE |
6548923 | A | FALSE |
6548923 | B | TRUE |
6548923 | D | FALSE |
14834568 | D | FALSE |
14834568 | D | FALSE |
8746985 | A | FALSE |
8746985 | B | TRUE |
8746985 | D | TRUE |
<tbody>
</tbody>
The closest I get is this array formula:
{=SUM(IF(FREQUENCY(IF($C$2:Report!$C$10<>"";IF($L$2:$L$10="FALSE";IF($G$2:$G$10="D";MATCH("~"&$C$2:$C$10;$C$2:$C$10&"";0))));ROW($C$2:$C$10)-ROW($C$2)+1);1))}
Desperately need help!