Forum Discussion
Susangreen15
Sep 28, 2022Copper Contributor
Formula to count Alpha Cells
I am trying to count the number of cells that have alpha data in a column. Column E has either RN, EN or AIN. Column F has alpha data in some rows. I would like a count of how many cells in Column F...
- Sep 28, 2022
Harun24HR
Sep 28, 2022Bronze Contributor
Susangreen15 Give a try to the following formula-
=FILTER(E1:E10000,ISNUMBER(SEARCH(E1:E10000,"RN|AIN|EN"))*(F1:F10000<>""))