So, I have got this lovely Array formula:
=IFERROR(INDEX('Raw Data'!I:I,SMALL(IF(SEARCH("Invalid",'Raw Data'!$I$3:$I$50&"Invalid")>1,ROW('Raw Data'!$I$3:$I$50)),ROWS($1:2))),"")
Essentially, if it finds a value “Invalid” in the referenced cells, it won’t populate that info. If it doesn’t, it will populate it.
Part of what I’m doing is assigning comments to the Raw Data being referenced. Is it possible to dynamically add the comments of the referenced cells into the non-“Invalid” cells being populated into these new cells?
Hopefully that’s not too complicated. What I’m doing is adding in images as comments to some of the original data and want it so I can hover over the filtered, non-”Invalid” data and see the associated image.
Thanks!
Bookmarks