Hi,
I am trying to find on how to find unique value based on two column. Column C must be repeated based on how much unique value available in column D
Current formula used in column C is
={IFNA(INDEX($A$1:$A$6,MATCH(0,COUNTIF($C$1:C1,$A$1:$A$6),0)),"")}
Current situation
<tbody>
</tbody>
Intended Result
<tbody>
</tbody>
OR
<tbody>
</tbody>
I am trying to find on how to find unique value based on two column. Column C must be repeated based on how much unique value available in column D
Current formula used in column C is
={IFNA(INDEX($A$1:$A$6,MATCH(0,COUNTIF($C$1:C1,$A$1:$A$6),0)),"")}
Current situation
A | B | C | D | |
---|---|---|---|---|
1 | Co Code | Country | Formula 1 | Formula 2 |
2 | PXAB | IN | PXAB | IN |
3 | PXAB | CN | PXBB | CN |
4 | PXBB | CN | ||
5 | PXBB | IN | ||
6 | PXBB | IN | ||
11 | ||||
12 | ||||
13 |
<tbody>
</tbody>
Intended Result
A | B | C | D | |
---|---|---|---|---|
1 | Co Code | Country | Formula 1 | Formula 2 |
2 | PXAB | IN | PXAB | IN |
3 | PXAB | CN | PXBB | IN |
4 | PXBB | CN | PXAB | CN |
5 | PXBB | IN | PXBB | CN |
6 | PXBB | IN | ||
11 | ||||
12 | ||||
13 |
<tbody>
</tbody>
OR
A | B | C | D | |
---|---|---|---|---|
1 | Co Code | Country | Formula 1 | Formula 2 |
2 | PXAB | IN | PXAB | IN |
3 | PXAB | IN | PXBB | IN |
4 | PXBB | CN | PXBB | CN |
5 | PXBB | IN | ||
6 | PXBB | IN | ||
11 | PXAB | IN | ||
12 | ||||
13 |
<tbody>
</tbody>