Hello,
in column A there is a list of letters (a,b,c) ... I'm trying to have results in columns D, E, F (for each letter one column).
How I can count how many times letter "a", "b", "c" didn't appear in column A?
Problem is, when some letter appears many times in a row I don't want to show that in the results. In the results must be only how many times letter didn't appear.
I attached the xls document with result in first rows for easier understanding.
Bookmarks