| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif only when an exact match occurs
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| CountIF columnH2-H101 the number of time between ages 20-29 occurs | Excel Worksheet Functions | |||
| Using COUNTIF to find how many times 2004 occurs | Excel Worksheet Functions | |||
| formula to extract specific data if match occurs | Excel Worksheet Functions | |||
Threaded Mode
