Hello there,

I'm currently working on a operation report for my company. I was using non array INDEX formula to list down all non empty cells on row $Y$2:$ADV$2.

I want to create a hyperlink to on each cell to link which cell the result was pointing towards.

I have my original formula right here:

=IF(INDEX(BTU!$Y$2:$ADV$2,COLUMNS($C$2:$C2),ROWS($C$2:$C2))=0,"",INDEX(BTU!$Y$2:$ADV$2,COLUMNS($C$2:$C2),ROWS($C$2:$C2)))

I'm having a hard time to create a hyperlink result.

Can anyone save me???