This is the formula I'm using in a calculated column:
<tbody>
</tbody>
This isn't what expect. I expect that this would put a 0 in cells 2-4 in the calculated column. If I was using basic Excel formulas it would look like this: =IF(SUMPRODUCT($A2:A2=A2)*($B2:B2=B2))>1,0,1)
I also tried EARLIEST to see if that changed things - no. I'm just trying to find unique instances of various combinations of data.
Thanks in advance.
=IF(
CALCULATE(COUNTROWS(Table1),
FILTER(Table1,
Table1[Column1]=EARLIER(Table1[Column1]) &&
Table1[Column2]=EARLIER(Table1[Column2])
)
)>1,0,1
)
Column1 | Column2 | CalculatedColumn |
Billy | Yes | 1 |
Billy | Yes | 1 |
Billy | Yes | 1 |
Billy | Yes | 1 |
<tbody>
</tbody>
This isn't what expect. I expect that this would put a 0 in cells 2-4 in the calculated column. If I was using basic Excel formulas it would look like this: =IF(SUMPRODUCT($A2:A2=A2)*($B2:B2=B2))>1,0,1)
I also tried EARLIEST to see if that changed things - no. I'm just trying to find unique instances of various combinations of data.
Thanks in advance.