On 6 Jul 2006 13:32:34 -0700, "S Davis" wrote:

Sorry Ron. Im basically trying to break down any number into an equal
number of whole parts. If the number were 23, i wanted to develop some
way to break that down into steps of 1,2,3,4....23, using only the cell
containing 23 to do it with.

It seemed pointless after awhile and I just used offset to display my
ranking and then divided by that. Sorry its confusing, it was more a
fun exercise than anything else. id still like to see someone do it.

Example - (1/23)*23 = 1. (2/23)*23=2. The challenge is in coming with a
way to replace the "1" or "2" with a number equal to "1" or "2" by only
using the number "23". ie, (FORMULA/A1)*A1=2.

Try this:

Put your number in A1 -- e.g. 10.25 or 23.

B1: =IF(ROWS($1:1)$A$1,"",ROWS($1:1))


Copy/drag down as far as you want.
--ron