COUNTIF says Null = Blank but Blank <> Null

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Epinn - 25 Oct 2006 04:58 GMT

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/microsoft.public.excel.worksheet.functions/browse_
frm/thread/9c20d4fa89998634?scoring=d&hl=en

or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn

Reply to this Message

Roger Govier - 25 Oct 2006 08:26 GMT

Epinn

>which led Sandy to do hers

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.

Signature

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/microsoft.public.excel.worksheet.functions/browse_
frm/thread/9c20d4fa89998634?scoring=d&hl=en

or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn

Reply to this Message

Epinn - 25 Oct 2006 19:02 GMT

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.

>> Sandy is a much used shorten form of the name Alexander...... <<

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

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.

Signature

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/microsoft.public.excel.worksheet.functions/browse_
frm/thread/9c20d4fa89998634?scoring=d&hl=en

or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn

Reply to this Message

Biff - 25 Oct 2006 19:12 GMT

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.

>> Sandy is a much used shorten form of the name Alexander...... <<

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

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.

Signature

Regards

Roger Govier

"Epinn" <someone@example.com.NO_SPAM> wrote in message
news:%23kz4eq%239GHA.3644@TK2MSFTNGP02.phx.gbl...
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/microsoft.public.excel.worksheet.functions/browse_
frm/thread/9c20d4fa89998634?scoring=d&hl=en

or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn

Reply to this Message

Epinn - 25 Oct 2006 20:03 GMT

>> Sandy is a much used shorten form of the name Alexander...... <<

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

"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message news:ueSNhbA#GHA.4544@TK2MSFTNGP05.phx.gbl...
Epinn

>which led Sandy to do hers

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.

Signature

Reply to this Message