| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting occurrences
How can I determine the number of equal (=) signs are in my
spreadsheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting occurrences
Presuming 1 per cell , Find "=", Find All
GARY wrote: How can I determine the number of equal (=) signs are in my spreadsheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting occurrences
Each cell contains varying numbers of = signs.
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting occurrences
Open a copy of the file and do a find and replace, say "=" with "#" ,
Replace All, it will give you a count of all the replacements. GARY wrote: Each cell contains varying numbers of = signs. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of occurrences. | Excel Worksheet Functions | |||
| counting random occurrences | Excel Discussion (Misc queries) | |||
| Counting occurrences on a particular date | Excel Worksheet Functions | |||
| Counting number of occurrences | Excel Worksheet Functions | |||
| counting occurrences in a range | Excel Discussion (Misc queries) | |||
Linear Mode
