March 22, 2026•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

submitted by /u/flyingGay
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel compatibility

#Excel alternatives for data analysis

#Excel alternatives

#rows.com

#duplicate routes

#Excel

#sheet

#ROUTE

#DEPARTURE

#DESTINATION

#fields

#data organization

#route identification

#organized

#1 and 3

#noob

#help

#example

#table