PassMeTheFormula
New Member
- Joined
- May 4, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, I'm looking for a formula to return the most commonly occurring text in a range minus a specific phrase. Is there anything I can add somewhere into the formula I already have, which returns the most commonly occurring text? Or do I need to rewrite what I already have?
Here's what I have already to return the text that appears the most in my range:
=INDEX(F2:F1022,MODE(IF(F2:F1022<>"",MATCH(F2:F1022,F2:F1022,0))))
The text I'm looking to exclude in the count is "Website/Portal".
TIA!
Here's what I have already to return the text that appears the most in my range:
=INDEX(F2:F1022,MODE(IF(F2:F1022<>"",MATCH(F2:F1022,F2:F1022,0))))
The text I'm looking to exclude in the count is "Website/Portal".
TIA!
