Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting occurences of a substring in a range of cells.
Thank you in advance for all replies.
I have a column in a worksheet which contains a series of 2 character codes separated by commas: ac, bg, hj, r4, qt, mr ac,mr,t7 mr,e3,bg search will return a value for starting position in each cell, and countif will return a count, but mixing the two together escapes me. Sure there's a way. (SQL is sooooo much easier.) Jeff N. Cantwell Downtown Little Rock NRA, ARPA, Libertarian '86, '91 300zx 2+2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif argument for 3 occurences of which 1 refers to a range | Excel Discussion (Misc queries) | |||
counting a cell range within a range | Excel Worksheet Functions | |||
Counting within a filtered range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |