I want to check dup by row condition as below.
- CusName and PlanCode as same → check value in column FPP —> keep row that FPP
most value - CusName and PlanCode as same → value in column FPP same value ----> keep 1 row
Please guide me about it.
remark : Real Data have 1K rows
input2.xlsx (9.7 KB)