103 reputation
3
bio website
location United Kingdom
age 29
visits member for 5 years, 4 months
seen Nov 12 at 9:11

I write Direct3D graphics drivers for a graphics hardware company.


May
10
awarded  Scholar
May
10
comment Spreadsheets: How do I perform functions on a set/array described by a row of (count, value) pairs?
Sorry for delay; away from excel. I marked the other answer correct as I could edit it better, not that I understand either. Both work, of course. This answer has the problem of not working if the initial (count, value) pair has a value of 0, though the same pair will work elsewhere in the sequence. Thanks for the anwer.
May
10
accepted Spreadsheets: How do I perform functions on a set/array described by a row of (count, value) pairs?
May
10
comment Spreadsheets: How do I perform functions on a set/array described by a row of (count, value) pairs?
Sorry for delay; away from excel. I marked this correct as I could edit this one better than the other answer, not that I understand either. Both work, of course. This answer has the problem of not giving a good end value, but that can be worked out from the start/end values. It also handles a initial value of 0 :). Thanks for the answer.
Apr
19
asked Spreadsheets: How do I perform functions on a set/array described by a row of (count, value) pairs?
Sep
15
awarded  Supporter
Jul
31
awarded  Autobiographer