Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to count cell text by value
Hi
I'm trying to write a formula that searches a range to values based on but I can't get it to work. The range is column C the problem is when I get to a postcode that has only 1 letter. I am currently using sumproduct to check the range and using left(B37, 2) to get only the first 2 letters. If B37 contains NG, I get the count of all postcodes with NG but some postcodes only have 1 letter. When this happens, I get ALL postcodes that start with N instead of postcodes that only have N is there a formula? I've been down the road of If Then formulas and countif etc but I can't make the filter. Any help would be really appreciated Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need Help with a count cell text formula | Excel Worksheet Functions | |||
count number of specified text within a text/cell | Excel Discussion (Misc queries) | |||
Formula text count | Excel Discussion (Misc queries) | |||
Formula text count | Excel Discussion (Misc queries) | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) |