| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting the total number of cells with specified condition(freque
Hi,
Can anyone pls tell me how do i count the total number of cells that has a certain word appear twice or nth times in a column? The below-mentioned will be the end result. The frequency will be specified by the user and excel will count the number of cells that has a certain word appearing twice in a column. Likewise, for Freqeuncy 3, sums the number of cells with that has a certain word in a string that appears thrice in the column. Frequency(input) Number of occurences(output) 2 10 3 \30 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions | |||
| Number Counting | Excel Discussion (Misc queries) | |||
| Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
| Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
| counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Threaded Mode
