Hi All
I've looked at recent questions similar to this to see if they would solve my issue but to no avail
I need the COUNTIF function to count a range of cells what include certain text but not the whole cell
For example cell C2 contains ABC 1.2.3 A1 - ALPHA cell C3 contains ABC 1.2.4 A2 - BRAVO
I want the function to count the cell content upto the .3 or .4 ignoring anything after that as the codes only vary after the last .number
Please help
Thanks all
Dan
Bookmarks