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???
Bookmarks