LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default How to put data into different buckets. - PLEASE HELP

I have thousands of rows of data that have one column that I need tohave a
formula that counts how many within three years and puts it into the correct
three different buckets accordingly.
ex.
0-2 3-5 5-10 and so forth.
Columbus
Louisville

i need it to look through one column and when it matches look at the length
of service column and it is between 0-2 it would count as 1 and go to the
next columbus match and length of service and so forth.

After that I need to do the same thing but instead of counting i need the
formula to add up the dollars according to $0-$100, $500-$1000 ect. and sum
up the dollars per market.

PLEASE HELP ME!!!!!!!!!!!!!!!!!!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning Dollar Values to 'Buckets' Suzanne Excel Discussion (Misc queries) 5 July 30th 08 01:36 PM
formula involving buckets Taylor Excel Worksheet Functions 2 June 19th 08 09:34 PM
Moving data into different buckets (tax preparation) Vicky Excel Discussion (Misc queries) 1 April 8th 08 06:17 PM
how do i put dates into workweek buckets in excel ricardomanet Excel Discussion (Misc queries) 1 August 8th 07 06:30 PM
Data Buckets (in a range) salireza Excel Discussion (Misc queries) 1 August 14th 06 08:42 AM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"