You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
Ok.
You can do this a couple of ways, I think.
If I’m teaching you to suck eggs right now i apologise in advance and I’m not trying to be a patronising prick.
You can use ifs or a lookup to define the ranges of your spend (like we did a couple of posts back?). So in a cell next to your actual and potential spend you’ll have the grouped value.
Then in another part of the spreadsheet or another sheet you’ll have your groups of data (100001 etc) and just use a countif to look at the field with the group category.
Your groups you’re using aren’t real numbers. The row formulae aggi gave you (or the sequence fill) are concatenations of two values to form a category. You’re moving a continuous variable (the price) into a categorical variable.
You can also do pivot grouping to get you there as well.