Nguyen Anh Dung
Board Regular
- Joined
- Feb 28, 2020
- Messages
- 180
- Office Version
- 2016
- Platform
- Windows
could you explain your logic?after remove duplicates from 3 columns together: 962
8686 remove duplicates=>481 rows. if keep only 2 rows the same, but columns B and C have different values that do not overlap 962 rows.
after remove duplicates from 3 columns together: 962 rows or 964
Yes, i only want remove duplicate but keep two rowanyway I think if you do that with footoo's way your data will not be consistent after filtering
anyway I think if you do that with footoo's way your data will not be consistent after filtering
I give up.Yes, i only want remove duplicate but keep two row
But the OP needs to check to see if it does what he wants.but I tried and it works
Yes, Best regards and thanks you so much!!!not correct. you can help me vba?
link file: test.csv