I find myself wanting to do this quite regularly and spend ten minutes trying to figure out how to do it and never get anywhere...
The scenario is, I've got a data series - e.g. in a column 1000 rows in length - for example sales transaction values against customers. When I start the process, I don't know anything about the data values - I don't know anything about the average, how many values are 10% higher than average what are the sensible bands and I want a process which does the following:
1) analyse the data
2) figure out a set of bands (e.g. values between $10 and $30, $31 and $50, $51-$100)
3) Attach the relevant band to each value (e.g. in the column next to it...) - that bit is relatively straight forward with a vlookup for example...
The second process of creating sensible bands is what I keep scratching my head over...
Anyone done this before and or anyone got any suggestions?
The scenario is, I've got a data series - e.g. in a column 1000 rows in length - for example sales transaction values against customers. When I start the process, I don't know anything about the data values - I don't know anything about the average, how many values are 10% higher than average what are the sensible bands and I want a process which does the following:
1) analyse the data
2) figure out a set of bands (e.g. values between $10 and $30, $31 and $50, $51-$100)
3) Attach the relevant band to each value (e.g. in the column next to it...) - that bit is relatively straight forward with a vlookup for example...
The second process of creating sensible bands is what I keep scratching my head over...
Anyone done this before and or anyone got any suggestions?
