| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF says Null = Blank but Blank < Null
I started a thread with a casual comment on COUNTIF and blank and zero. Then I did more tests which led Sandy to do hers and discover that according to COUNTIF
"" = Blank but Blank < "" Roger confirmed the finding by doing a detailed and interesting test using various versions of Excel (starting from 97). Kudos to both of them. Since we have spent quite a bit of time in this investigation, I want to share our "discovery" with all. So, I hereby invite everyone to take a look at the experiment. If you don't want to go through the entire thread, you can just click on post #25 by Roger. Please feel free to comment, but please include it under the other thread. Here is the link:- http://groups.google.ca/group/micros...coring=d&hl=en or http://tinyurl.com/y6fowz Roger, I appreciate your effort. Epinn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif not blank | Excel Worksheet Functions | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions | |||
Threaded Mode
