Counting steps in a scale
Hi,
If you just want to enter numbers space in Any steps enter the first two
number is two adjacent cells, lets say -1 into A1 and 1 into A2. Highlight
both and drag the fill handle down.
All evenly spaced numerical or date sequences can be produced this way.
--
Thanks,
Shane Devenshire
"DirkG" wrote:
Hello,
I've been searching for an option in Excel which counts the steps between
scales.
For instance; -1 to 1 is 2 steps (-1 to 0 is 1 step, 0 to 1 is 1 step).
Is there actually an option available in Excel 2003 which provides this
feature?
Hope any of you can help.
Thanks for the time.
Dirk
|