Unlucky
Board Regular
- Joined
- Dec 3, 2014
- Messages
- 58
- Office Version
- 2016
- Platform
- Windows
Most frequent recurring text. I was able to enter the most frequent formula, but I'm having difficulty with the 2nd, 3rd, 4th, and 5th most frequent.
I use column D for a program name ($D$:$D$121)
I use column E for the recurring text I want to search for ($E$2:$E$121)
I use column F for the program name pool ($F$2:$F$14)
Column G ($G$2:$G$14) list the most frequent recurring text {=INDEX($E$2:$E$121,MODE(IF($D$2:$D$121=$F$2,MATCH($E$2:$E$121,$E$2:$E$121,0))))} . . . confirmed with Ctrl+Shift+Enter
Column H ($H$2:$H$14) is the 2nd most frequent recurring text
Column I ($I$2:$I$14) is the 3rd most frequent recurring text
Column J ($J$2:$J$14) is the 4th most frequent recurring text
Column K ($K$2:$K$14) is the 5th most frequent recurring text
Problem: I'm having trouble with entering the formula for columns H, I, J, & K
I use column D for a program name ($D$:$D$121)
I use column E for the recurring text I want to search for ($E$2:$E$121)
I use column F for the program name pool ($F$2:$F$14)
Column G ($G$2:$G$14) list the most frequent recurring text {=INDEX($E$2:$E$121,MODE(IF($D$2:$D$121=$F$2,MATCH($E$2:$E$121,$E$2:$E$121,0))))} . . . confirmed with Ctrl+Shift+Enter
Column H ($H$2:$H$14) is the 2nd most frequent recurring text
Column I ($I$2:$I$14) is the 3rd most frequent recurring text
Column J ($J$2:$J$14) is the 4th most frequent recurring text
Column K ($K$2:$K$14) is the 5th most frequent recurring text
Problem: I'm having trouble with entering the formula for columns H, I, J, & K