M
Mike
I have a column of data that contains text values such as "Branch" and
"Branch Remote". I need to count the occurrances for each but my Branch
count is including Branch Remote. The countif statements are
=COUNTIF('1208ATMDispatches'!$B$10:$B$63,"Branch*")
=COUNTIF('1208ATMDispatches'!$B$10:$B$63,"Branch Remote*")
I am using the * because the source data has a space after Branch and also
after Branch Remote.
How can I do an exact match using the countif statement.
Any help would be appreciated.
Thanks,
Mike
"Branch Remote". I need to count the occurrances for each but my Branch
count is including Branch Remote. The countif statements are
=COUNTIF('1208ATMDispatches'!$B$10:$B$63,"Branch*")
=COUNTIF('1208ATMDispatches'!$B$10:$B$63,"Branch Remote*")
I am using the * because the source data has a space after Branch and also
after Branch Remote.
How can I do an exact match using the countif statement.
Any help would be appreciated.
Thanks,
Mike