| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif not finding all the required data
Ctrl+F is able to search within cells, thus counting "FF2 ". COUNTIF looks at
entire cell. If there's no similar data, you might try a find&replace of: Find: *FF2* Replace: FF2 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* " wrote: Hi, thanks for your replies. I tried "ctrl+f" to find all "FF2"'s and it fuond 12. My formula only found 10 and then there is 1 in the table heading and the left over one is in my data field which I have highlighted with all my other data. Argh this is so annoying! Thanks guys. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Required data in one sheet | Excel Worksheet Functions | |||
| finding data entry required cells by highlighting. | Excel Discussion (Misc queries) | |||
| Help required with COUNTIF/AND function | Excel Worksheet Functions | |||
| Help required with Consolidating Data | Excel Worksheet Functions | |||
| Data manipulation help required ! | Excel Worksheet Functions | |||
Threaded Mode
