Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
=COUNTIF(A1:A7,"*d")
assuming these entries are in a1 to a7 "jayender.vs" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
Hi Jayender,
Try: =COUNTIF(C:C,"m") =COUNTIF(D:D,"d") --- Regards, Norman "jayender.vs" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
R.VENKATARAMAN Wrote: =COUNTIF(A1:A7,"*d") assuming these entries are in a1 to a7 thanks VENKATARAMAN, as i said , am new to excel.. so where should i need to give the code mentioned? i know its silly waiting for ur responce .. thanks, ja -- jayender.v ----------------------------------------------------------------------- jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864 View this thread: http://www.excelforum.com/showthread.php?threadid=48303 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
Wow , thatks dude. thatks Norman Jones ,VENKATARAMAN!! thanks a lot. is there anyway to "Rate the post" ? just curious -- jayender.v ----------------------------------------------------------------------- jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864 View this thread: http://www.excelforum.com/showthread.php?threadid=48303 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
Hey then dude, got one doubt say i need to calculate number of "m" present in the column.. its like this max, matter, mass, apple, orange... and from this i need to count number of words starting with letter "m". how to do it? waiting for ur responce. thanks, jay -- 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
Hi Jayender,
Try: =COUNTIF(C:C,"m*") --- Regards, Norman "jayender.vs" wrote in message ... Hey then dude, got one doubt say i need to calculate number of "m" present in the column.. its like this max, matter, mass, apple, orange... and from this i need to count number of words starting with letter "m". how to do it? waiting for ur responce. thanks, jay -- 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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
Thanks Norman, thanks a lot... and one more is there anyway to rate the post -- jayender.v ----------------------------------------------------------------------- jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864 View this thread: http://www.excelforum.com/showthread.php?threadid=48303 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
select any empty cell and type that formula
"jayender.vs" wrote in message ... R.VENKATARAMAN Wrote: =COUNTIF(A1:A7,"*d") assuming these entries are in a1 to a7 thanks VENKATARAMAN, as i said , am new to excel.. so where should i need to give the code u mentioned? i know its silly waiting for ur responce .. thanks, jay -- 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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
No way but to respond with your appreciation which you have.
-- Regards, Tom Ogilvy "jayender.vs" wrote in message ... Thanks Norman, thanks a lot... and one more is there anyway to rate the post? -- 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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
count number of "D"
I see you are posting from the Excel forum. However, the answers you
received are from the publick newsgroup news://msnews.microsoft.com/microsof...el.programming Excel forum just sucks in the information from there. Unless someone has sandwich board information on the bottom of their post like you have: jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640 View this thread: http://www.excelforum.com/showthread...hreadid=483035 the answer is probably from the newsgroup and not from the excel forum. You can connect directly to usenet using the above link if you wish. -- Regards, Tom Ogilvy "jayender.vs" wrote in message ... Thanks Norman, thanks a lot... and one more is there anyway to rate the post? -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
Count the number of cells that conatin a "." in a range | Excel Worksheet Functions | |||
How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Count the number of Lines in a "wrap text"-cell | Excel Discussion (Misc queries) |