Calculate How the Number of Specific word.
 

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.

Calculate How the Number of Specific word.
 

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

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Khalid A. Al-Otaibi" wrote:

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.