+ Reply to Thread
Results 1 to 3 of 3

Get remarks value base on the CODE No. and Unique no.

  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Get remarks value base on the CODE No. and Unique no.

    The scenario is have 3 different names but same CODE LIST and unique No. assigned Every names have a specific CODE and unique no. to put a remarks.
    And on my side I want to get all the remarks base of the CODE and unique no. List of 3 Different names. That's why I put the TEST_001, TEST_002 and TEST_003.

    I want to get the marks base on the CODE no. and unique no. In column C Sheet 2, Put the remarks base on the CODE no. and Unique No. in Sheet name "DATA"
    I attached Image for the data and expected result. Also i put the example documents. and some here give me formula but now i need to add the with unique no.Thank you so much in advance.
    Here's the formula that get only the remarks base on the Code No. not included the unique no. Thank you in advance.

    =IFERROR(INDEX(Data!$C:$C,AGGREGATE(15,6,ROW(Data!$C$2:$C$55)/((Data!$B$2:$B$55=$D3)*(Data!$C$2:$C$55<>"")),COUNTIF($D$3:$D3,$D3))),"")

    This the DATA
    Provided Data.PNGProvided Data.PNG

    This is the expected result
    Expected Result.PNG

    I'm still searching and working for the solution wish anyone here help me. Thank you very much to this forum.
    Attached Files Attached Files
    Last edited by jasond1992; 05-22-2021 at 03:43 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,226

    Re: Get remarks value base on the CODE No. and Unique no.

    You've marked this as solved - is it?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,598

    Re: Get remarks value base on the CODE No. and Unique no.

    May be this
    In E3 copied up to Column G and down.

    =IFERROR(INDEX(Data!B:B,AGGREGATE(15,6,ROW(Data!$D$2:$D$55)/((Data!$D$2:$D$55<>"")),ROWS($E$3:$E3))),"")
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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] get remarks value base on the right CODE No.
    By jasond1992 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-10-2021, 10:14 AM
  2. VBA code to specify the Hyperlink base box
    By Gryfphon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2017, 05:15 PM
  3. How to sum a column base on a few unique criterias
    By greatutopia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2014, 04:32 AM
  4. [SOLVED] In Remarks Column the Remarks should be as described as the attached excel file
    By robin.das077 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2013, 03:38 AM
  5. Code that generates a unique save path base on specific user
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2013, 08:54 AM
  6. Updating data in 2 different speadsheet Base on unique User ID
    By snsavidg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2012, 03:38 PM
  7. How do i set up a data base in excel for code 128
    By charlieking4747 in forum Excel General
    Replies: 1
    Last Post: 06-09-2006, 01:30 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