| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting similar text
Help! I'm stumped. If column A is list of colours , with 100 text entries (rows) and the word 'Green' appears randomly 32 times, Blue 41 times and Red 27 times. What is the formulae that would produce the result of Green 32, Blue 41, Red 27. Garyadders - novice -- garyadders ------------------------------------------------------------------------ garyadders's Profile: http://www.excelforum.com/member.php...o&userid=28691 View this thread: http://www.excelforum.com/showthread...hreadid=483781 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting text only | Excel Worksheet Functions | |||
| Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
