First time here? Check out the FAQ!
I have a column of text based codes. Some end with F, some with A and some with - .
A1 KnotsP-A A2 SaucyF-- A3 B-SweP-F A4 StancF-F A5 RoothF-F A6 GrainF-- A7 RavenP-F A8 GermaP-A A9 ParkeF-F A10 LucieFE- A11 Top MPEF A12 WarneF-F
I would like to be able to count how many end with F. I have tried a number of variations suce as: =countif(A1:A12,.f) and =countif(A1:A12,".F") and =countif(A1:A12,"=.F") but they do not work. =countif(A1:A12,"W.") works, returns 1
Please note that the formulae include the wildcard asterix but they don't seem to show up on this blog.
Any help would be great.
answered 2012-07-16 00:06:13 +0200mariosv
answered 2013-02-21 05:58:24 +0200mahfiaz
You could always create a new column which has only the last character, e.g with this formula:
TRIM() removes leading and trailing whitespace, RIGHT() picks given number of last characters and UPPER() converts everything to UPPERCASE.
How to count certain characters?
answered 2013-02-20 11:01:38 +0200ROSt52
Could this be a possibility: Use right(cell, lenght(cell)-1) to identify the most right character and then work with countif?
answered 2012-07-16 00:30:52 +0200Farmer Bob
Thanks but that gives a result of 0.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-15 23:27:54 +0200
Seen: 736 times
Last updated: Feb 21