Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting non-numeric values T. Valko Excel Discussion (Misc queries) 2 January 2nd 08 02:59 AM
Counting non-numeric values JE McGimpsey Excel Discussion (Misc queries) 1 January 2nd 08 02:41 AM
Counting non-numeric values Ron Coderre Excel Discussion (Misc queries) 1 January 2nd 08 02:40 AM
Counting non-numeric values Chip Pearson Excel Discussion (Misc queries) 1 January 2nd 08 02:39 AM
Counting non-numeric values Rick Rothstein \(MVP - VB\) Excel Discussion (Misc queries) 0 January 1st 08 11:12 PM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"