| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count-formula used for words
You can use the COUNTIF function to count specific words
You can use SUMPPRODUCT to count unique words Example: A1 the A2 boy A3 ran A4 fast A5 boy A6 =COUNTIF(A1:A5,A1) returns 1 A7 =COUNTIF(A1:A5,"boy") returns 2 A8 =SUMPRODUCT(--(COUNTIF(D3:D8,D3:D8)=1)) returns 3 If you need something more specific, then be more specific with your question. "Vic1978" wrote: Is it possible to count different words? If yes how is the formula? Thanks! -- Vic1978 ------------------------------------------------------------------------ Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708 View this thread: http://www.excelforum.com/showthread...hreadid=507211 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| More Help Needed with Count formula | Excel Worksheet Functions | |||
| Count If formula | Excel Discussion (Misc queries) | |||
| Count numbers formed from another formula | Excel Discussion (Misc queries) | |||
Threaded Mode
