Hi,

I am trying to count the number of individuals in two seperate columns on
the same spreadsheet:
For exemple, in my column A, some cells have "Robert" and in Column B, some
cells have "Robert". I want to know how many times we have "Robert" side by
side.
Cell A1 = Robert and Cell B1 = Robert
I dont want to count all the other cells where Robert is shown but not
beside another Robert

Many Thanks

Robert