#### Asfandyar Ali

##### Member

Is there any way to increment red highligted function automatically whenever i paste the formula in below cells?

=INDEX($A$2:$A$21,AGGREGATE(15,6,IF(FREQUENCY(MATCH($A$2:$A$21&"",$A$2:$A$21&"",0),MATCH($A$2:$A$21&"",$A$2:$A$21&"",0))>0,ROW($A$2:$A$21)-ROW($A$2)+1),

**1))**