View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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