PC Review


Reply
Thread Tools Rate Thread

Count Number of CF Q

 
 
Seanie
Guest
Posts: n/a
 
      20th Jul 2010
Would it be posssible to Count the number of CF instances in each
sheet and display results in a message box?

eg

Sheet1 = 5
Sheet2 = 10
Sheet3 = 7
etc etc
 
Reply With Quote
 
 
 
 
Jim Cone
Guest
Posts: n/a
 
      20th Jul 2010

The free Formats & Styles add-in counts CF conditions in the entire workbook and displays a cell count...
http://excelusergroup.org/media/
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware



"Seanie" <(E-Mail Removed)>
wrote in message
news:748f8931-1443-4e9a-b1dc-(E-Mail Removed)...
Would it be posssible to Count the number of CF instances in each
sheet and display results in a message box?
eg

Sheet1 = 5
Sheet2 = 10
Sheet3 = 7
etc etc
 
Reply With Quote
 
Seanie
Guest
Posts: n/a
 
      20th Jul 2010
many thanks Jim, exactly what I was after

 
Reply With Quote
 
Jim Cone
Guest
Posts: n/a
 
      20th Jul 2010
You are welcome. Glad to get the feedback.
'--
Jim Cone




"Seanie" <(E-Mail Removed)>
wrote in message
news:de0cac20-f0b2-49a0-90a5-(E-Mail Removed)...

many thanks Jim, exactly what I was after

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Count that will display the number for each record in the count increment. Sylvain Lafontaine Microsoft Access ADP SQL Server 0 12th Jul 2008 04:25 PM
Pie Chart report based off count of items less than a number and greater than a number NeoFax99@gmail.com Microsoft Access 2 5th Dec 2006 12:14 PM
Count rows and insert number to count them. =?Utf-8?B?TWV4?= Microsoft Excel Misc 6 23rd Aug 2006 02:29 AM
count each cell that have a number and take that number and count. =?Utf-8?B?Vmljaw==?= Microsoft Excel Misc 3 19th May 2006 01:51 AM
Number count - postcodes and need to count the numbers of tim... =?Utf-8?B?TWFyayAtIEF1c3Q=?= Microsoft Excel Misc 1 24th Oct 2005 10:00 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:20 AM.