Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-07-2011, 06:58 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline A couple of questions Windows 7 32bit A couple of questions Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Q1 The formula approach would be to use COUNTIF(). Alternatively you can use a Pivot Table

Q2 You need to format the cells as Text before you enter the digit ranges. If these digit ranges are going to be referenced or used to calculate buckets elsewhere, then you would be better off putting the start/end values in separate cells

eg

A
1
5
6
7
13
14
etc
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
A couple of questions installation questions, can you help? boho774 Office 4 12-28-2010 10:00 AM
Two questions from a novice alexB Word 0 08-11-2010 08:47 AM
Semi-flexible templates (couple of questions) mshanks Word 1 07-29-2009 06:35 AM
Noob questions punktilend Word 0 07-24-2009 02:41 AM
A couple of questions Comment on asking questions here zyzzyva57 Word 5 06-17-2009 04:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft