Hướng dẫn how do you divide data into intervals in excel? - làm thế nào để bạn chia dữ liệu thành các khoảng trong excel?

11-24-2009, 10:35 AM #2

Re: split data into ranges

try =countifs[A:A,">=1",A:A,"&lt;=5"] </blockquote> </div> </div> </div> <div class="cleardiv"></div> </div> </div> <div class="postfoot"> <div class="textcontrols floatcontainer"> <span class="postcontrols" style="width:60%"> <img style="display:none" id="progress_2204752" src="//www.excelforum.com/images/misc/progress.gif" alt /> <a id="qrwq_5837" class="newreply" href="//www.excelforum.com/register.php" rel="nofollow"><img id="quoteimg_5837" src="//www.excelforum.com/clear.gif" alt="Reply With Quote" />Register To Reply</a> </span> <span class="postlinking"> </span> </div> </div> <hr /> </li> <li class="postbitlegacy postbitim postcontainer old" id="post_2204778"> <div class="posthead"> <span class="postdate old"> <span class="date">11-24-2009, <span class="time">11:09 AM</span></span> </span> <span class="nodecontrols"> <a name="post2204778" href="//www.excelforum.com/excel-general/708485-split-data-into-ranges.html#post2204778" class="postcounter">#3</a><a id="postcount2204778" name="3"></a> </span> </div> <div class="postdetails"> <div class="userinfo"> <div class="username_container"> <div class="popupmenu memberaction"> <a class="username offline popupctrl" href="//www.excelforum.com/members/105847.html" title="DonkeyOte is offline"><strong><font color="Blue">DonkeyOte</font></strong></a> <ul class="popupbody popuphover memberaction_body"> <li class="left"> <img src="//www.excelforum.com/images/site_icons/profile.png" alt /> <a href="//www.excelforum.com/members/105847.html"> View Profile </a> </li> <li class="right"> <img src="//www.excelforum.com/images/site_icons/forum.png" alt /> <a href="//www.excelforum.com/search.php?do=finduser&amp;userid=105847&amp;contenttype=vBForum_Post&amp;showposts=1" rel="nofollow"> View Forum Posts </a> </li> </ul> </div> <img class="inlineimg onlinestatus" src="//www.excelforum.com/images/statusicon/user-offline.png" alt="DonkeyOte is offline" border="0" /> </div> <span class="usertitle"> Forum Guru </span> <span class="postbit_reputation" id="repdisplay_2204778_105847" title="DonkeyOte has a reputation beyond repute"> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_pos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_pos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_pos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_pos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_pos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_highpos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_highpos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_highpos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_highpos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_highpos.png" alt /> <img class="repimg" src="//www.excelforum.com/images/reputation/reputation_highpos.png" alt /> </span> <a class="postuseravatar" href="//www.excelforum.com/members/105847.html" title="DonkeyOte is offline"> <img src="//www.excelforum.com/avatars/105847.gif?dateline=1325349017" alt="DonkeyOte's Avatar" title="DonkeyOte's Avatar" /> </a> <hr /> <dl class="userinfo_extra"> <dt>Join Date</dt> <dd>10-22-2008</dd> <dt>Location</dt> <dd>Essex, UK</dd> <dt>MS-Off Ver</dt> <dd>O365</dd> <dt>Posts</dt> <dd>21,528</dd> </dl> <div class="imlinks"> </div> </div> <div class="postbody"> <div class="postrow has_after_content"> <h2 class="title icon"> Re: split data into ranges </h2> <div class="content"> <div id="post_message_2204778"> <blockquote class="postcontent restore "> <div style="float:right"> <script type="text/javascript"><!-- google_ad_client = "pub-8275723683113357"; /* excelforum 300x250 */ google_ad_slot = "9830241510"; google_ad_width = 300; google_ad_height = 250; //-->