COUNTIF says Null = Blank but Blank <> Null

  • Thread starter Thread starter Epinn
  • Start date Start date
E

Epinn

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/micro...e_frm/thread/9c20d4fa89998634?scoring=d&hl=en


or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn
 
Epinn
which led Sandy to do hers
Click to expand...
I may be entirely wrong, but I believe Sandy to be male and not female.
Sandy is a much used shorten form of the name Alexander, certainly in
Scotland, which (proudly) is Sandy's home.

--
Regards

Roger Govier


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/micro...e_frm/thread/9c20d4fa89998634?scoring=d&hl=en


or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn
 
Yes, I have been wondering about the gender of Sandy. I do know that the name Sandy can be for both, same as Terry, Robin, Sam, ..... same as [E]lectronic [PIN] [N]o. can be odd or even.

The first time I saw the name "Sandy," I was fixated on "female." Then one day, I said to myself: Sandy is probably male. When I posted, I totally forgot about that. You know how first impression sticks ...... If Sandy doesn't tell us, we'll never find out; and we'll assume Sandy is a male.

I didn't know that. Hey, I even learn about names on this board. Great!! One time, I learned a Japanese phrase from another board and of course Welsh from this board.

Epinn

which led Sandy to do hers
Click to expand...
I may be entirely wrong, but I believe Sandy to be male and not female.
Sandy is a much used shorten form of the name Alexander, certainly in
Scotland, which (proudly) is Sandy's home.

--
Regards

Roger Govier


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/micro...e_frm/thread/9c20d4fa89998634?scoring=d&hl=en


or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn
 
Dana Delouis ?

Biff

Yes, I have been wondering about the gender of Sandy. I do know that the
name Sandy can be for both, same as Terry, Robin, Sam, ..... same as
[E]lectronic [PIN] [N]o. can be odd or even.

The first time I saw the name "Sandy," I was fixated on "female." Then one
day, I said to myself: Sandy is probably male. When I posted, I totally
forgot about that. You know how first impression sticks ...... If Sandy
doesn't tell us, we'll never find out; and we'll assume Sandy is a male.

I didn't know that. Hey, I even learn about names on this board. Great!!
One time, I learned a Japanese phrase from another board and of course Welsh
from this board.

Epinn

Epinn
which led Sandy to do hers
Click to expand...
I may be entirely wrong, but I believe Sandy to be male and not female.
Sandy is a much used shorten form of the name Alexander, certainly in
Scotland, which (proudly) is Sandy's home.

--
Regards

Roger Govier


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/micro...e_frm/thread/9c20d4fa89998634?scoring=d&hl=en


or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn
 
Yes, I have been wondering about the gender of Sandy. I do know that the name Sandy can be for both, same as Terry, Robin, Sam, ..... same as [E]lectronic [PIN] [N]o. can be odd or even.

The first time I saw the name "Sandy," I was fixated on "female." Then one day, I said to myself: Sandy is probably male. When I posted, I totally forgot about that. You know how first impression sticks ...... If Sandy doesn't tell us, we'll never find out; and we'll assume Sandy is a male.

I didn't know that. Hey, I even learn about names on this board. Great!! One time, I learned a Japanese phrase from another board and of course Welsh from this board.

Epinn

which led Sandy to do hers
Click to expand...
I may be entirely wrong, but I believe Sandy to be male and not female.
Sandy is a much used shorten form of the name Alexander, certainly in
Scotland, which (proudly) is Sandy's home.

--
Regards

Roger Govier


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/micro...e_frm/thread/9c20d4fa89998634?scoring=d&hl=en


or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn
 
Back
Top