Hello everyone,
I have a question about sliders.
I have a column with different values in it, all numbers. I have a separate cell that calculates a range within that column. Say for example, =Average(A1:A12)
Ok, my question is, can I design some sort of 'slider' that expands or contracts the range that this simple average formula is looking at? So by moving the slider a number of clicks, the formula suddenly becomes =Average(A1:A20)
My head hurts from trying to work this one out. Someone, said it might be possible with VBA? But no idea what this means.
Anyway, help, solutions, or pointers in the right direction would be very very gratefully received!
Many thanks to you all!
nick (london)
I have a question about sliders.
I have a column with different values in it, all numbers. I have a separate cell that calculates a range within that column. Say for example, =Average(A1:A12)
Ok, my question is, can I design some sort of 'slider' that expands or contracts the range that this simple average formula is looking at? So by moving the slider a number of clicks, the formula suddenly becomes =Average(A1:A20)
My head hurts from trying to work this one out. Someone, said it might be possible with VBA? But no idea what this means.
Anyway, help, solutions, or pointers in the right direction would be very very gratefully received!
Many thanks to you all!
nick (london)