fill series that runs along opposite axis?

From: Anne1320 <Anne1320.2a9r8z_1151761501.7137_at_excelforum-nospam.com>
Date: Sat, 1 Jul 2006 08:40:56 -0500

I can’t even figure out how to ask this!

How do I create a custom fill series/use some formula(?) that will: increase linearly with a step value of 1, but along the opposite axis from the direction of the target cells. For example,

A1=B1*24
How do I then fill down column A so that:

A2=C1*24
A3=D1*24
A4=E1*24

Etc.

Also need to do the opposite:

B1=A1*24
C1=A2*24
D1=A3*24

I feel like there should be an easy way to do this, but for the life of me…! Thanks for any suggestions.

-- 
Anne1320
------------------------------------------------------------------------
Anne1320's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35969
View this thread: http://www.excelforum.com/showthread.php?threadid=557570

Received on Sat Jul 01 2006 - 06:40:56 PDT