Calculate How the Number of Specific word.

  • Thread starter Thread starter Khalid A. Al-Otaibi
  • Start date Start date
K

Khalid A. Al-Otaibi

Valid
Expired
Valid
Valid
Expired

Is there any way of how can I calculate the number of a word in a column?.

For Example I want to Calculate How many [Valid] in Column A.
 
Assume that you are having the below values in A Column

Row / Col A Col
Row1 Valid
Row2 Expired
Row3 Valid
Row4 Valid
Row5 Expired

CHOICE 1:-
Copy and paste the below formula in B1 Cell
=COUNTIF(A:A,A1)
Copy the B1 cell and paste it to the remaining cells of B Column based on
the A Column Data

CHOICE 2-
Copy and paste the below formula in C1 Cell
=A1&" "&COUNTIF(A:A,A1)
Copy the B1 cell and paste it to the remaining cells of C Column based on
the A Column Data
 
Back
Top