T
T Newbery
I have three ranges e.g.
Range 1 Range 2 Range 3
Bread Apples Bread
Apples Oranges Buns
Oranges Pears
Buns
Bread
Pears
Apples
I'm trying to construct a formula that counts the number of times, say, and
entry in Range 3 appears in Range 1 - In this instance the answer would be 3.
Range 1 Range 2 Range 3
Bread Apples Bread
Apples Oranges Buns
Oranges Pears
Buns
Bread
Pears
Apples
I'm trying to construct a formula that counts the number of times, say, and
entry in Range 3 appears in Range 1 - In this instance the answer would be 3.