How do i highlight the most repeated combination of values on a list?

[pandapanda12]

Hello guys, im not really into excel or spread sheet in general so any help is really appreciated.

I have this example below:

With table set like that, lets say i want to find the most repeated combination (at least 3 names) from the B column. What is the easiest way to do that?

I know there's a menu on finding and highlighting repeated phrase, but what if its several phrase combination?



Thanks for any feedback!

 

[pandapanda12]

This is the example of what i want it to look like

 

[sparky2205]

What about a conditional formatting rule: =COUNTIF($B$2:$B$28,B2)>2

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How do i highlight the most repeated combination of phrase on a list?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[pandapanda12]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How do i highlight the most repeated combination of phrase on a list?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

my bad, apologies