copy the data based on same total number between 2 sheets

[reza_doang]

Hi All -

need your help
i hope i can explain it with well

i want to copy data column based on total of number.
let says, I have the master data in sheet 1
and sheet 2, is my working sheet.

- in sheet 2 100200 has 2 line then it will copy the data from master data (sheet 1).
- in sheet 2 100300 has 1 line, while in master has 2 lines, so it will ignore
- in sheet 2 100400 has 1 line, while in master don't have that number, so it will ignore
- in sheet 2 300100 has 3 line, same with in master sheet, has 3 line, so it will copy the number.

based on this sample, is it possible to do that?

Master Data (Sheet 1)

Numbers	Item
100200	1
100200	2
100300	1
100300	2
300100	1
300100	2
300100	3

<tbody>
</tbody>

Working sheet (Sheet 2)

Numbers	Expected result
100200	1
100200	2
100300	NA
100400	NA
300100	1
300100	2
300100	3

<tbody>
</tbody>

Thank you in advance

regards,
reza

 

[aqeelnokia99]

FORmula in sheet 2 cell B2

=IF(COUNTIF($A$2:$A$8,A2)=COUNTIF(Sheet1!$A$2:$A$8,Sheet2!A2),INDEX(Sheet1!$B$2:$B$8,AGGREGATE(15,6,ROW($A$2:$A$8)-ROW($A$2)+1/(A2=Sheet1!$A$2:$A$8),COUNTIF($A$2:A2,A2))),"NA")


NOTE:
incress range as your data range