1. V

    Unique value based on multiple column

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

Some videos you may like

This Week's Hot Topics