+ Reply to Thread
Results 1 to 2 of 2

Dynamically adding comments to cells through an array (see formula inside)

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    detroit, michigan
    MS-Off Ver
    Excel 2003
    Posts
    60

    Dynamically adding comments to cells through an array (see formula inside)

    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!

  2. #2
    Registered User
    Join Date
    05-20-2013
    Location
    detroit, michigan
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Dynamically adding comments to cells through an array (see formula inside)

    To follow up a bit if it wasn't clear, essentially, if there is a comment in one of the Raw Data cells, I want it to bring that comment over with the data in the cell if it is not "Invalid" if it has a comment.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VLOOKUP inside array formula
    By dipique in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-02-2013, 06:24 PM
  2. How do I Loop Dynamic Comments Placed Dynamically in different cells
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2011, 07:40 PM
  3. Adding comments to cells via macro
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2009, 10:56 AM
  4. adding conditional inside formula...
    By lespaul42 in forum Excel General
    Replies: 1
    Last Post: 02-28-2009, 01:25 PM
  5. Adding comments to cells
    By Bope in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2008, 04:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1