Hi,
I'm just trying to create a formula where for a given column it will only return a value say "X", if a specific "word" (e.g Rob) is repeated more then 3 times immediately in a row below or above it, otherwise return "A". For example:
Rob -X
Rob -X
Rob -X
Rob -X
Janet -A...