I have a list of dollar values and a list of bins. While i can get the
frequency of each value in corresponding bin.... is there an easy way to get
the bin assigned to the dollar value, in the data? Suppose my bins were in
incriments of 5 for the example below (5, 10 , 15, 20, 25) Column A are my
dollar values; i'd like column B to populate with the appropriate bin.
A B
2.00 5
11.00 15
8.00 10
12.00 15