Nguyen Anh Dung
Board Regular
- Joined
- Feb 28, 2020
- Messages
- 180
- Office Version
- 2016
- Platform
- Windows
yes, In case column A is the same, but B and C have different values, how do we do?Select column A
Data>Data Tools>Remove Duplicates
Select data that remains, copy, paste underneath
Sort column A
Your sample data only showed column A.yes, In case column A is the same, but B and C have different values, how do we do?
Date/time | Latitude | Longitude |
18/03/2020 03:20:07 | 10.8179718 | 106.6320324 |
18/03/2020 03:20:07 | 10.8179728 | 106.6320376 |
18/03/2020 03:20:07 | 10.8179742 | 106.6320433 |
18/03/2020 03:20:07 | 10.8179754 | 106.6320498 |
18/03/2020 03:20:08 | 10.8179572 | 106.6319321 |
18/03/2020 03:20:08 | 10.817959 | 106.6319386 |
18/03/2020 03:20:08 | 10.8179596 | 106.6319564 |
18/03/2020 03:20:08 | 10.8179596 | 106.6319605 |
18/03/2020 03:20:08 | 10.8179596 | 106.6319647 |
18/03/2020 03:20:08 | 10.8179601 | 106.6319529 |
18/03/2020 03:20:08 | 10.8179603 | 106.6319492 |
18/03/2020 03:20:08 | 10.8179604 | 106.6319451 |
18/03/2020 03:20:08 | 10.8179605 | 106.6319707 |
18/03/2020 03:20:08 | 10.8179615 | 106.6319773 |
18/03/2020 03:20:08 | 10.8179622 | 106.6319828 |
18/03/2020 03:20:08 | 10.8179628 | 106.6319879 |
18/03/2020 03:20:08 | 10.8179635 | 106.6319932 |
18/03/2020 03:20:08 | 10.8179641 | 106.6319983 |
18/03/2020 03:20:08 | 10.8179651 | 106.6320041 |
18/03/2020 03:20:08 | 10.8179666 | 106.6320101 |
18/03/2020 03:20:08 | 10.8179681 | 106.6320159 |
18/03/2020 03:20:08 | 10.8179699 | 106.6320222 |
18/03/2020 03:20:08 | 10.817971 | 106.6320275 |
not correct. you can help me vba?Enter in D2 and fill down to last data row : =IF(COUNTIF(A$2:A2,A2)>2,"d",1)
Select column D and go to SpecialCells>Formulas>Text
Delete>EntireRow
Clear column D