#NUM! How to fix

[Malcolm torishi]

Does anyone know how to get fix an #NUM ! error so the cell is blank and not have this #NUM ! In . I have the following formula that puts this error in the cell
=IF(C7="-","",IF(C7="","",IF(ROW()-ROW($BA$6)-COUNTA($AA$7:$AA$32)>0,"",INDEX($C$7:$C$32,AGGREGATE(15,6,ROW($AA$7:$AA$32)-ROW($AA$6)/($AA$7:$AA$32=BB7),COUNTIF($BB7:$BB$26,BB7))))))
thank you if you can help

 

[DataBlake]

try

=iferror(IF(C7="-","",IF(C7="","",IF(ROW()-ROW($BA$6)-COUNTA($AA$7:$AA$32)>0,"",INDEX($C$7:$C$32,AGGREGATE(15,6,ROW($AA$7:$AA$32)-ROW($AA$6)/($AA$7:$AA$32=BB7),COUNTIF($BB7:$BB$26,BB7)))))),"")

Edit:
*note that excel will not view this cell as truly empty because of the formula so if you were running some type of vba or formula afterwards that detects blanks you may need to change the "" to " " and do a find and replace " " to ""

 

[Malcolm torishi]

Thank you