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!!!!!!!!!!!!!!!!!!!
|