Can anyone help with this scenario I have a data that have different name but same CODE No. I want to get the marks base on the CODE no. In column B Sheet 2 will put the marks base on the CODE no. in Sheet DATA.
I attached Image for the data and expected result. Also i put the example documents. Thank you in advance.
This the data Sheet name: DATA
Data.PNG
and this is the expected result Sheet name Sheet2
Attachment 731829
Last edited by jasond1992; 05-10-2021 at 10:09 AM.
Should the first CODE in G4 be 111-221? Since there is "x" for that code, also 111-222 has only one "x"
Try in J4:
Drag down and accross to column K
Please Login or Register to view this content.
Quang PT
oww i'm so sorry it's "111-222" I'll try your formula. Thank you sir for your reply.
I've tried it sir but the result that I got is the CODE no. and also sir I'm confused about G4 cause on my example is not included the G Column. all i want is to put the remarks value base on the Code No.
Last edited by jasond1992; 05-10-2021 at 01:17 AM.
In E3 then copied down
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you so much sir for you help But sir don't need to mention the TEST_001. I Just want to put all the marks from DATA to the specific CODE number in Sheet2
In E3 and copied down
=IFERROR(INDEX(Data!$C:$C,AGGREGATE(15,6,ROW(Data!$C$2:$C$19)/(Data!$B$2:$B$19=$D3),COUNTIF($D$3:$D3,$D3))),"")
the result sir stop on 111-225 only gets the TEST_001 marksOriginally Posted by kvsrinivasamurthy
111-226 onwards is 0 result didn't get the other
Last edited by jasond1992; 05-10-2021 at 04:36 AM.
The formula in post #2 gives your expected results (if you follow the instruction about copying Across and Down)
What is the criteria to change over from _001 to _002. It is changing 225 to 226. But both names contain these codes.
The scenario sir is have 3 different names but same CODE LIST. Every names have a specific CODE to put a remarks.
And on my side I want to get all the remarks base of the CODE List of 3 Different names. That's why I put the TEST_001, TEST_002 and TEST_003.
Not required in your original post!
Try
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($C$2:$C$55)/($C$2:$C$55<>""),ROW(1:1))),"")
Copy across and down
In E3 then copied down
Please Login or Register to view this content.
Thank you so much sir.It's working.
The results are the same as those from the formula given in post #2!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks