+ Reply to Thread
Results 1 to 7 of 7

Find matched values and put as comment

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    11

    Find matched values and put as comment

    Hi,

    I have searched the forum for solution but could not find anything.
    I have the following situation.

    Below you can see a report which contains request ID number, requester name and type of request.
    Well below you may see summary of the report in the form of pivot table. The table contains count of ID numbers based on name and type criteria. For example, Parvin had 4 requests for the type of FO. What I need is to put actual ID numbers in the corresponding cell as comment. So, for those 4 requests the comment should contain
    1930663; 1926508; 1926354; 1925646


    ID Requester name Type
    1930663 Parvin FO
    1930222 Parvin OG
    1930048 Parvin OG
    1929218 Parvin OG
    1928270 Parvin OG
    1926727 Parvin CC
    1926508 Parvin FO
    1926354 Parvin FO
    1926041 Parvin CC
    1925793 Parvin OG
    1925646 Parvin FO
    1925562 Samir OG
    1925557 Samir OG
    1925534 Samir FO
    1925411 Samir OG
    1925410 Samir OG
    1925401 Samir OG
    1925399 Samir CC Sup
    1925312 Samir CC Sup
    1925213 Samir OG
    1925207 Sara OG
    1925206 Sara OG
    1925157 Sara OG
    1925128 Sara CC Sup

    FO OG CC CC Sup
    Parvin 4 5 2 0
    Samir 1 6 0 2
    Sara 0 3 0 1

    I would appreciate if someone helps me with this.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Find matched values and put as comment

    Not sure it is possible to put comment in a Pivot Table and if it were possible to put comment in the cell used by the PT you will mess up the comment when you refresh the PT.
    I suggest to use formulas with macros
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    05-17-2011
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Find matched values and put as comment

    I also think that macros is needed. It would be great if someone shared a code, even if it is draft version.

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Find matched values and put as comment

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can use this formula. Example XL is attached for your information pls.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Find matched values and put as comment

    Is it what you need: Try and commentActive sheet must be the sheet to treat
    Formulas are prepared for 1000 rows, it can be adjusted
    The display is done in the activesheet
    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Find matched values and put as comment

    For the fun a remake without formulas
    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-17-2011
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Find matched values and put as comment

    Thank you a lot, PCI. I will check both versions.

+ 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] Match values from two different columns and sort according to the matched values
    By kongfookann in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-20-2013, 09:44 AM
  2. Replies: 2
    Last Post: 06-18-2013, 07:45 AM
  3. Find a match btw two workbooks and insert row below the matched value in wBook2
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 10:51 PM
  4. find matched character and pull it next to the cell
    By dontdont in forum Excel General
    Replies: 3
    Last Post: 11-24-2011, 05:36 AM
  5. match columns and find the matched Part number
    By rajivs27 in forum Excel General
    Replies: 5
    Last Post: 02-17-2010, 04:46 PM
  6. find and copy matched cell on other worksheet
    By pso51 in forum Excel General
    Replies: 6
    Last Post: 10-11-2007, 01:26 PM
  7. find and copy matched cell on other worksheet
    By pso51 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2007, 01:02 PM
  8. find and copy matched cell on other worksheet
    By pso51 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2007, 01:00 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