open the excel file you can use any sql db to work on
and do 2 Queries according to the following explanation
And the results according to the examples
The results should be saved in an Excel or CSV file
Send me the query too
1. Each ID number from column L should have only one product of each type, a product type listed in column A.
2. Each order number from column J may have only one product of each type
In column A
Find which ID numbers from column L
There is more than one type of product, and what is the order number listed in column J
And what are the products that have more than one
output samle in excel csv
L = 330810144- : J = 1167 : A = 824,823
Find out which order number from column J has more than one type of product, and what the identification number in column L is, and what are the products that have more than one.
output sample: in excel or in csv
J = 1753 : -L = 217357839 : A = 824,823
14 freelanceria on tarjonnut keskimäärin 21$ tähän työhön
I'm highly skilled C# programmer and Desktop developer, worked with Excel many times before and (SQL, Oracle, MS Access), please contact me to discuss details and chat.