Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Another Excel Question - Grouping Data


  • Please log in to reply

#1
PGH

PGH

    Member

  • Member
  • PipPip
  • 36 posts
I have another quick Excel 2002 question:

If Excel is given a list of numbers, say all between 10 and 40, can it sort them into groups which you specify (eg. 10-20, 21-30, 31-40) and if so how is this done? I have tried searching Google and Excel help for this, but I haven't turned up exactly what I want to do.

AND on a similar note can Excel make grouped frequency tables - so if you still have, say, your numbers between 10 and 40 and you specify the same groups again can Excel tell you the frequency of numbers from your original list which fit into your groups?

eg.

Numbers: 10, 15, 35, 27, 11, 19

Groups: Frequency:

10-20 4

21-30 1

31-40 1


Thanks :tazz:

Edited by PGH, 18 February 2006 - 06:20 AM.

  • 0

Advertisements


#2
PGH

PGH

    Member

  • Topic Starter
  • Member
  • PipPip
  • 36 posts
I have actually worked this one out myself, using this tutorial ( http://www.meadinkent.co.uk/xlfreq.htm ) thanks for answering my other question yesterday, anyway.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP