Search condition in DataGrid View

  • Thread starter Thread starter ahmeddc
  • Start date Start date
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

1617046.png


Another picture after reaching the Required

1617047.png

data

Excel file with data

drive

Continue reading...
 
Back
Top