A
ahmeddc
Guest
Hi
I have DataGridView with only 4 columns.
The first column is the product name
Second column discount
The third column is the price
The fourth column is the company name.
This data comes from compiling more than one excel file. And I made that step
Required:
- Extracting the 3 biggest discounts per product, where the product name and price are similar with the same product and price for another company.
-If there are only two discounts, they are automatically selected in case. IF there is one discounts, it is chosen directly.
and Delete all data that do not apply to the conditions 1-2
Image of the combined data
Another picture after reaching the Required
data
Excel file with data
drive
Continue reading...
I have DataGridView with only 4 columns.
The first column is the product name
Second column discount
The third column is the price
The fourth column is the company name.
This data comes from compiling more than one excel file. And I made that step
Required:
- Extracting the 3 biggest discounts per product, where the product name and price are similar with the same product and price for another company.
-If there are only two discounts, they are automatically selected in case. IF there is one discounts, it is chosen directly.
and Delete all data that do not apply to the conditions 1-2
Image of the combined data
Another picture after reaching the Required
data
Excel file with data
drive
Continue reading...