Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis was deceptively tricky. No delimiters, upper/lower case differentiation. Learnt how (?-i) will make REGEX_CountMtaches pay attention to case. Also didn't realise for ages that I needed a Cross Tab AND Transpose tool. Was getting confused why I couldn't do it in one tool.