Hi, sooo.....
I have list in table 1 (below) and I want to count in table 2, the number times the text in table 2 column A appear in the list from table 1. BUT i need to to exclude any entries that are in A4 or A5 from table2.
I can do count if but i cant figure out how to exclude.
for the count if ive got in table2 B1. =COUNTIF('table1'!$A:$A,"*"&A1&"*")
<tbody>
</tbody>
<tbody>
</tbody>
I have list in table 1 (below) and I want to count in table 2, the number times the text in table 2 column A appear in the list from table 1. BUT i need to to exclude any entries that are in A4 or A5 from table2.
I can do count if but i cant figure out how to exclude.
for the count if ive got in table2 B1. =COUNTIF('table1'!$A:$A,"*"&A1&"*")
A | |
1 | ab/home/west |
2 | ab/home/east |
3 | ab/home/east/up |
4 | ab/home/up |
5 | ab/home/down |
6 | ab/away/east |
7 | ab/away new/west |
8 | ab/state/east |
9 | ab/state new/east |
10 |
<tbody>
</tbody>
A | B | |
1 | up | |
2 | down | |
3 | east | |
4 | away | |
5 | state | |
6 | ||
7 | ||
8 | ||
9 |
<tbody>
</tbody>