Counting cells with a specified frequency(how many times it appear
Hi,
I want to sum up cells thats has any word appearing 10 times in the column. In the other words, the specified word can be anything. The end result is to the sum up cells that has any word appear 10 times in the column. eg. column 1 row 1 a two the row 2 two 924 the row 3 the desk to row 4 let's can to two if i want to sum up the cells that has any word appearing twice, the result will be 1 word frequency of 3, the answer will be 2 (row 1 - the & two, row 2, row 3 - the, row 4 two) Thanks |
All times are GMT +1. The time now is 10:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com