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