SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Hello all,
I'm using the Index, Mode and Match array formula to show the most frequently repeated text. However, I wonder if there's a formula to show if there is more than one match, i.e. three cooking and three exercise class):
Any advise would be gratefully received!
Ta muchly!
I'm using the Index, Mode and Match array formula to show the most frequently repeated text. However, I wonder if there's a formula to show if there is more than one match, i.e. three cooking and three exercise class):
Most Attended Activity | Cooking | Age Range Most Attended | 18 - 25 | ||
Number of Females | 2 | Most Common Housing Status | PRS | ||
Number of Males | 3 | Services Most Known To | RSI | ||
Number of Transgender | 1 | ||||
Type of Activity | Attendance Number | Gender | Age Range | Housing Status | Services Known To |
Cooking | Transgender | 18 - 25 | PRS | RSI | |
Cooking | Male | 18 - 25 | PRS | RSI | |
Cooking | Female | 26 - 35 | Rough sleeping | Homeworks | |
Exercise class | Male | 26 - 35 | Rough sleeping | Homeworks | |
Exercise class | Male | 46 and over | TA | RRP | |
Exercise class | Female | 46 and over | HF | None | |
Any advise would be gratefully received!
Ta muchly!