| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the number of days from a specific date | Excel Discussion (Misc queries) | |||
| How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
| Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
| Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
| Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
Hybrid Mode
