Hi All,
I am looking to generate an array of results linked to my data range.
Conditions are:
- Start from a minimum number within the data range
- fixed increments (hard coded) or linked to another cell
- End with a maximum number within the data range
e.g. if i have in my data range - {1,2,3,4,5,6,7,8,9,10}
and if my condition for increment is "0.50"
I am looking for a way to generate the array - {0.50,1,1.50,2,2.50,3,3.50,4,4.50,5,5.50,6,6.50,7,7.50,8,8.50,9,9.50,10}
Any help is appreicated.
Bookmarks