|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 5th, 2010, 06:39 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
April 5th, 2010, 07:53 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
