| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Within 6 months, Within 1 year and so on...
I am trying to take a column of data and 'bucket' it.
For example if the # of days is 124, I would like to display within 6 months. I will need to go up to 4 years in 6 month intervals with the data point falling into only one bucket. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Within 6 months, Within 1 year and so on...
With the number of days in A1.........
=LOOKUP(A1,{0,183,366,549,732,915,1098,1281},{1,2, 3,4,5,6,7,8}) hth Vaya con Dios, Chuck, CABGx3 "MER" wrote: I am trying to take a column of data and 'bucket' it. For example if the # of days is 124, I would like to display within 6 months. I will need to go up to 4 years in 6 month intervals with the data point falling into only one bucket. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup returns wrong value | Excel Worksheet Functions | |||
| holiday dates | Excel Worksheet Functions | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| Locate particular months sale with year | New Users to Excel | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Hybrid Mode
