If a variable in column A fulfills a certain condition, I have it listed in column B
Column A
Q
W
E
R
T
Y
C
O
M
P
U
T
E
R
If the letter is a vowel, I want to list it in column B ( = if(A1=vowel,A1,"") (this isn't the exact formula-- I know this wouldn't work-- but it's just for the idea)
So in Column B I get
E
Y
O
U
E
..with blank ("") cells between.
How can I count these items in the next column? I want:
E 1
Y 2
O 3
U 4
E 5
without the blank cells in between counted.
Any suggestions?
Thanks.