E
Els
There is probably a straightforward answer to this but if someone could offer
assistance that would be great.
I am looking to create a formula which would show me how many times 2
entries appear in the same row of a spreadsheet e.g.
Column A Column B Column C
Rod Jan Monday
Jane Dec Friday
Freddy Feb Monday
Jane Mar Tuesday
Peter Oct Friday
Jane May Friday
In the above example I would like a formula to show me how many times both
Jane AND Friday appear together. The result I would be looking for would be 2.
Any help would be greatly appreciated
assistance that would be great.
I am looking to create a formula which would show me how many times 2
entries appear in the same row of a spreadsheet e.g.
Column A Column B Column C
Rod Jan Monday
Jane Dec Friday
Freddy Feb Monday
Jane Mar Tuesday
Peter Oct Friday
Jane May Friday
In the above example I would like a formula to show me how many times both
Jane AND Friday appear together. The result I would be looking for would be 2.
Any help would be greatly appreciated