|
Counting words............
How can I give the total of how many times a word appears in a column? -- Smokey_Vol ------------------------------------------------------------------------ Smokey_Vol's Profile: http://www.excelforum.com/member.php...o&userid=29717 View this thread: http://www.excelforum.com/showthread...hreadid=495182 |
Counting words............
Smokey_Vol Wrote: How can I give the total of how many times a word appears in a column? Assuming your column range is A1:A100, you can use this =COUNTIF(A1:A100,\"WORD_THAT_NEEDS_TO_BE_COUNTED\" )[/b] OR IF THE WORD THAT YOU WANT TO COUNT IS, SAY, IN CELL B1, THE ABOVE FORMULA CAN BE MODIFIED TO BE [b]=COUNTIF(A1:A100,\"*\"&B1&\"*\") Hope this is what you looking for. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=495182 |
| All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com