Hi.
i want to Find the Same data in Row and find different Row values to "output" sheet
1.Find the Same data between Sheet1 and Sheet2 (Find only two or more duplicates)
2.if data in sheet1 and sheet2 have the same number and equal counted then to skip
3.if data in sheet1 and sheet 2 have not the same number and not equal counted to Value to "output" sheet
Ex.
Sheet 1
Check 4853,Check1275,Check19960 (Find only two or more duplicates)
Sheet 2
Check 4853 = 2 Row, (equal to Sheet 1 to skip)
Check1275 =1 (not equal to Sheet 1(have 3 Row ) Value to "output" sheet
Check9960 =1 (not equal to Sheet 1(have 2 Row ) Value to "output" sheet
Output
i want to Find the Same data in Row and find different Row values to "output" sheet
1.Find the Same data between Sheet1 and Sheet2 (Find only two or more duplicates)
2.if data in sheet1 and sheet2 have the same number and equal counted then to skip
3.if data in sheet1 and sheet 2 have not the same number and not equal counted to Value to "output" sheet
Ex.
Sheet 1
Check 4853,Check1275,Check19960 (Find only two or more duplicates)
Output_Packageพฤษภาคม_2023.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Merchant ID | Device ID | Operation time | Operation status | ||
2 | 230330 | 4853 | 2023-05-20 00:02:32 | Succeed | ||
3 | 230330 | 4853 | 2023-05-20 00:21:42 | Succeed | ||
4 | 230330 | 1275 | 2023-05-20 09:36:11 | Succeed | ||
5 | 230330 | 1275 | 2023-05-20 13:49:01 | Succeed | ||
6 | 230330 | 1275 | 2023-05-20 15:16:03 | Succeed | ||
7 | 230330 | 7832 | 2023-05-20 15:30:59 | Succeed | ||
8 | 230330 | 7399 | 2023-05-20 17:07:12 | Succeed | ||
9 | 230330 | 9960 | 2023-05-20 17:27:08 | Succeed | ||
10 | 230330 | 9960 | 2023-05-20 20:02:52 | Succeed | ||
11 | ||||||
12 | ||||||
13 | ||||||
14 | ||||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
Sheet1 |
Sheet 2
Check 4853 = 2 Row, (equal to Sheet 1 to skip)
Check1275 =1 (not equal to Sheet 1(have 3 Row ) Value to "output" sheet
Check9960 =1 (not equal to Sheet 1(have 2 Row ) Value to "output" sheet
Output_Packageพฤษภาคม_2023.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | No | Bank Loc | BankCode | Receipt Date | ||
2 | 1 | 86140 | 4853 | 5/17/2023 | ||
3 | 2 | 86140 | 4853 | 5/17/2023 | ||
4 | 3 | 86140 | 1275 | 5/17/2023 | ||
5 | 4 | 86131 | 1275 | 5/17/2023 | ||
6 | 5 | 86131 | 1275 | 5/17/2023 | ||
7 | 6 | 86131 | 7832 | 5/17/2023 | ||
8 | 7 | 86131 | 7399 | 5/17/2023 | ||
9 | 8 | 86211 | 9960 | 5/17/2023 | ||
10 | 9 | 86211 | 9960 | 5/17/2023 | ||
11 | 10 | 86212 | 629 | 5/17/2023 | ||
12 | 11 | 86212 | 629 | 5/17/2023 | ||
13 | ||||||
14 | ||||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
19 | ||||||
20 | End of Report | |||||
21 | ||||||
22 | ||||||
sheet2 |
Output
Output_Packageพฤษภาคม_2023.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | No. 1 | Merchant ID | Device ID | Operation time | Operation status | ||
2 | 230330 | 1275 | 2023-05-20 09:36:11 | Succeed | |||
3 | 230330 | 1275 | 2023-05-20 13:49:01 | Succeed | |||
4 | 230330 | 1275 | 2023-05-20 15:16:03 | Succeed | |||
5 | No | Bank Loc | BankCode | Receipt Date | |||
6 | 86140 | 1275 | 5/17/2023 | ||||
7 | |||||||
8 | No. 2 | Merchant ID | Device ID | Operation time | Operation status | ||
9 | 230330 | 9960 | 2023-05-20 17:27:08 | Succeed | |||
10 | 230330 | 9960 | 2023-05-20 20:02:52 | Succeed | |||
11 | No | Bank Loc | BankCode | Receipt Date | |||
12 | 8 | 86211 | 9960 | 5/17/2023 | |||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
output |