I just asked ChatGPT to create a formula in Excel to tally the number of times a name was mentioned. I knew it was a simple count of formula but this took the guess work out. Copy and paste straight into excel, assign the relevant cells and BAM! Worked like a charm!