View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
infinite1013 infinite1013 is offline
external usenet poster
 
Posts: 13
Default Strategizing numbers

I have a wide range of varying dollar amounts that I want to group together
depending on the range in which they fall. I need a percentage of how many
figures fall into each range.What would be th best way to do this?

Example:

Values:
$1,765.02
$568.71
$1,141.22

Ranges-
$549.99-599.99
$600.00-649.99
$650.00-699.99 etc.