LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default count number of "D"


Hi dude,
I am new to excel .. here is my requirements.

Code:
--------------------

449 78 d
449 69 m d
458 260 m
469 28 m
472 39 m
479 51 d
484 59 m d
--------------------

i need to count number of "d" present in the 4 th column and number of
m present in the 3 column.. its a very big table and i need to
calculate programically.
how to do it?

thanks in advance !!


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

 
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
Create Pivot Table Data with Column "Sum" rather than "count" defa Johnny_99[_2_] Excel Discussion (Misc queries) 2 January 2nd 10 03:25 PM
Count the number of cells that conatin a "." in a range Jonathan Brown Excel Worksheet Functions 5 February 5th 09 11:00 PM
How to Count the number of "rows" (or Array items) included in a Sumif formula? EagleOne Excel Discussion (Misc queries) 3 July 30th 07 06:25 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Count the number of Lines in a "wrap text"-cell MichaelS_ Excel Discussion (Misc queries) 2 March 20th 06 08:15 AM


All times are GMT +1. The time now is 11:44 AM.

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

About Us

"It's about Microsoft Excel"