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

COUNTIF says Null = Blank but Blank < Null
 

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.

--
Regards

Roger Govier


"Epinn" wrote in message
...
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

COUNTIF says Null = Blank but Blank < Null
 

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

"Roger Govier" wrote in message ...
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.

--
Regards

Roger Govier


"Epinn" wrote in message
...
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

COUNTIF says Null = Blank but Blank < Null
 

Dana Delouis ?

Biff

"Epinn" wrote in message
...
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

"Roger Govier" wrote in message
...
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.

--
Regards

Roger Govier


"Epinn" wrote in message
...
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

COUNTIF says Null = Blank but Blank < Null
 

"Epinn" wrote in message ...
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

"Roger Govier" wrote in message ...
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.

--
Regards

Roger Govier


"Epinn" wrote in message
...
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