Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Bin to Value
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Bin to Value
Put the bins in a separate column, say F1 thru F6:
0 5 10 15 20 25 with your data in A1 thru A4, In B1 put: =VLOOKUP(A1,F$1:F$6,1,TRUE)+5 and copy down to display: 2 5 11 15 8 10 12 15 -- Gary''s Student - gsnu200840 "Suzanne" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Bin to Value
Thanks a million.
-- Thank you -- Suzanne. "Gary''s Student" wrote: Put the bins in a separate column, say F1 thru F6: 0 5 10 15 20 25 with your data in A1 thru A4, In B1 put: =VLOOKUP(A1,F$1:F$6,1,TRUE)+5 and copy down to display: 2 5 11 15 8 10 12 15 -- Gary''s Student - gsnu200840 "Suzanne" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning Macros | Excel Worksheet Functions | |||
assigning # to day | Excel Worksheet Functions | |||
Assigning a Value | Excel Discussion (Misc queries) | |||
assigning a unique value | Excel Worksheet Functions | |||
Assigning a value to a name | Excel Worksheet Functions |