LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
csfrolich
 
Posts: n/a
Default Counting occurance of letters or numbers

I am helping some one else .... so excuse the limited and continuation of
questions I may plan to ask.

I have a columns with 1 character entry... in 11 rows

Column A

x
0 This column to the left, I want to count the # of x's,
which is 5 in this
2 example
3
_
x Immediately underneath the answer above
0 I would also like to count the number of time #s 1-7
show up and 0
x needs to be omitted.. this example would be 2... the 2
and 3
_
r Some cells may have NO entry or blank indicated by _
x
x
I am not sure what the "r" is yet... But these
answered above will get me on my way.

Thanks for all the help
 
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
no row numbers or column letters DISPLAYED RagDyer Excel Discussion (Misc queries) 4 April 24th 23 03:42 AM
occurance of numbers in cell range Dillenger Excel Worksheet Functions 14 February 21st 05 06:45 PM
Excel column headings from numbers to letters happygolucky Excel Discussion (Misc queries) 2 January 21st 05 06:15 PM
Count the occurance of upper or lower case letters Sivsy Excel Worksheet Functions 3 January 13th 05 07:31 PM
Finding Numbers with Cells that also contain letters Adam Excel Discussion (Misc queries) 7 December 29th 04 02:41 PM


All times are GMT +1. The time now is 07:35 AM.

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"