I am having trouble working out a formula for this. Ideally what I want is a formula to do the following;
Find a name in column A, lets say Joe. And if Joe is in A4 count the amount of times FH shows in row 4
If this is possible, would it then be possible for the formula to find any specified name (perhaps from a drop down) and then return the amount of times FH appears in the same row as that?
Thanks in advance.
Bookmarks