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...