I have 2 separate codes listed below that I need to integrate together to perform my function. The first one grabs the information and inputs it into a new cell. The 2nd one sorts it in descending order. I need that 2 together but keep getting errors.
=IFERROR(INDEX($AR$1:$AR$62, SMALL(IF($AI$3=$AQ$1:$AQ$62, ROW($AQ$1:$AQ$62)-MIN(ROW($AQ$1:$AQ$62))+1, ""), ROW(F1))),"")
=IFERROR(INDEX($AR$1:$AR$62,MATCH(LARGE(IF(ISBLANK($AR$1:$AR$62),"",IF(ISNUMBER($AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62)+SUM(IF(ISNUMBER($AR$1:$AR$62),1,0))+1)),ROW()-ROW($AT$1)+1),IF(ISBLANK($AR$1:$AR$62),"",IF(ISNUMBER($AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62)+SUM(IF(ISNUMBER($AR$1:$AR$62),1,0))+1)),0)),”
=IFERROR(INDEX($AR$1:$AR$62, SMALL(IF($AI$3=$AQ$1:$AQ$62, ROW($AQ$1:$AQ$62)-MIN(ROW($AQ$1:$AQ$62))+1, ""), ROW(F1))),"")
=IFERROR(INDEX($AR$1:$AR$62,MATCH(LARGE(IF(ISBLANK($AR$1:$AR$62),"",IF(ISNUMBER($AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62)+SUM(IF(ISNUMBER($AR$1:$AR$62),1,0))+1)),ROW()-ROW($AT$1)+1),IF(ISBLANK($AR$1:$AR$62),"",IF(ISNUMBER($AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62),COUNTIF($AR$1:$AR$62,"<"&$AR$1:$AR$62)+SUM(IF(ISNUMBER($AR$1:$AR$62),1,0))+1)),0)),”