Counting non-numeric values
 

Did anyone else see a delay in the posting of the responses to this thread?
When I answered the OP, there were no other messages posted to the thread. I
went to eat supper about 25 minutes ago and I was the only message posted in
this thread. I just came back, refreshed the newsreader and... whoom... nine
messages popped up.

Rick


"paljowestsub" wrote in message
...
I have a spreadsheet with the letter x in various cells. I want to count
the
number of x's in a particular row of cells. What formula do I use and how
do
I structure the formula?

Thank you!
Joe Palczynski

Counting non-numeric values
 

On Tue, 1 Jan 2008 19:56:40 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Did anyone else see a delay in the posting of the responses to this thread?
When I answered the OP, there were no other messages posted to the thread. I
went to eat supper about 25 minutes ago and I was the only message posted in
this thread. I just came back, refreshed the newsreader and... whoom... nine
messages popped up.

Rick


I did not see any delay. When I downloaded I did not see any responses. But
Niek and I both apparently posted at 3:55 PM EST.

By the way, Rick, the "=x" in your solution can be replaced merely by "x"
--ron

Counting non-numeric values
 

Did anyone else see a delay in the posting of the responses to this
thread?
When I answered the OP, there were no other messages posted to the thread.
I
went to eat supper about 25 minutes ago and I was the only message posted
in
this thread. I just came back, refreshed the newsreader and... whoom...
nine
messages popped up.

I did not see any delay. When I downloaded I did not see any responses.
But
Niek and I both apparently posted at 3:55 PM EST.

Hmm! Thanks for the follow-up. I wonder why I saw the delay. I set up a
direct account to the microsoft news server, so its not like my ISP could
have been responsible or anything. Oh well, I guess its just one of those
mysteries of life or something.

By the way, Rick, the "=x" in your solution can be replaced merely by "x"

Yeah, I know... I just forgot about that when I created the response. <g

Rick

Counting non-numeric values
 

I think MS was having trouble with the newsservers for a few hours.

"Rick Rothstein (MVP - VB)" wrote:

Did anyone else see a delay in the posting of the responses to this thread?
When I answered the OP, there were no other messages posted to the thread. I
went to eat supper about 25 minutes ago and I was the only message posted in
this thread. I just came back, refreshed the newsreader and... whoom... nine
messages popped up.

Rick

"paljowestsub" wrote in message
...
I have a spreadsheet with the letter x in various cells. I want to count
the
number of x's in a particular row of cells. What formula do I use and how
do
I structure the formula?

Thank you!
Joe Palczynski

--

Dave Peterson

Counting non-numeric values
 

I saw a delay.

Using OE, there were no replies posted when I replied. After my reply didn't
show up I started looking around. CDO showed only Chip's reply. Google
Groups also didn't show any replies.

--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
Did anyone else see a delay in the posting of the responses to this
thread? When I answered the OP, there were no other messages posted to the
thread. I went to eat supper about 25 minutes ago and I was the only
message posted in this thread. I just came back, refreshed the newsreader
and... whoom... nine messages popped up.

Rick


"paljowestsub" wrote in message
...
I have a spreadsheet with the letter x in various cells. I want to count
the
number of x's in a particular row of cells. What formula do I use and how
do
I structure the formula?

Thank you!
Joe Palczynski

Counting non-numeric values
 

I think MS was having trouble with the newsservers for a few hours.

Thanks for responding Dave. Maybe the trouble they were having had to do
with purging all those MI5 spam messages that were posted earlier.<g

Rick

Counting non-numeric values
 

Thanks for responding Biff. Strange... I saw my own response quite quickly,
but no one else's for a long time.

Rick


"T. Valko" wrote in message
...
I saw a delay.

Using OE, there were no replies posted when I replied. After my reply
didn't show up I started looking around. CDO showed only Chip's reply.
Google Groups also didn't show any replies.

--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
Did anyone else see a delay in the posting of the responses to this
thread? When I answered the OP, there were no other messages posted to
the thread. I went to eat supper about 25 minutes ago and I was the only
message posted in this thread. I just came back, refreshed the newsreader
and... whoom... nine messages popped up.

Rick


"paljowestsub" wrote in message
...
I have a spreadsheet with the letter x in various cells. I want to count
the
number of x's in a particular row of cells. What formula do I use and
how do
I structure the formula?

Thank you!
Joe Palczynski

Counting non-numeric values
 

When I responded there were NO responses shown to me.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick Rothstein (MVP - VB)" wrote in
message ...
Thanks for responding Biff. Strange... I saw my own response quite
quickly, but no one else's for a long time.

Rick


"T. Valko" wrote in message
...
I saw a delay.

Using OE, there were no replies posted when I replied. After my reply
didn't show up I started looking around. CDO showed only Chip's reply.
Google Groups also didn't show any replies.

--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
Did anyone else see a delay in the posting of the responses to this
thread? When I answered the OP, there were no other messages posted to
the thread. I went to eat supper about 25 minutes ago and I was the only
message posted in this thread. I just came back, refreshed the
newsreader and... whoom... nine messages popped up.

Rick


"paljowestsub" wrote in message
...
I have a spreadsheet with the letter x in various cells. I want to count
the
number of x's in a particular row of cells. What formula do I use and
how do
I structure the formula?

Thank you!
Joe Palczynski