•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find duplicate routes in a sheet
Hi all,
I have a sheet organized in this way:
| ROUTE | DEPARTURE | DESTINATION |
|---|---|---|
| 1 | A | B |
| 2 | A | C |
| 3 | A | B |
| 4 | B | A |
I want to find all the duplicated routes, so, in this example, 1 and 3, that have the same departure and destination fields, without touching anything else. I'm a bit of a noob in Excel so any help is appreciated.
TIA
[link] [comments]
Want to read more?
Check out the full article on the original site