Prev: percentage in excel
Next: restrict view of certain cells in excel
From: Khalid A. Al-Otaibi on 5 Apr 2010 01:39
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.

From: Ms-Exl-Learner on 5 Apr 2010 02:53
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.
>
 | 
Pages: 1
Prev: percentage in excel
Next: restrict view of certain cells in excel