| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to find text and count it within an entire workbook
I have a workbook where there is nothing consistent or any named ranges. I
need to make a summary sheet and count everytime I have the word cable in the entire workbook in column B. I have tried different variations of countif, lookups and find but have not come up with a combination that works. My restraint is that I can't have a macro for this workbook. I really need some help, example below. A B 1 Cable 2 FSR 3 FRK 4 Wind Meter 5 Laptop Thanks in advance, Carrie -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find duplicates in entire workbook | Excel Discussion (Misc queries) | |||
| Find duplicates in entire workbook | Excel Discussion (Misc queries) | |||
| Using Find over entire workbook | Excel Programming | |||
| How do I count how often a text or number appears in entire worksh | Excel Discussion (Misc queries) | |||
| count text strings in an entire workbook | Excel Worksheet Functions | |||
Threaded Mode
