Circular Formula?

[SM Mister Moe]

I have 56 alphanumeric characters in A1 to A56. I am using =rand() i
B1 to B56 and RANK in C1 to C56. This gives me a random number
through 56 to correspond with my 56 alphanumeric characters. I am the
using INDIRECT to shuffle the letters in a random order, and OFFSET t
organize them. For space concerns, I want to format the result
differently about 50 rows down on the sheet. When I try going =e1 i
A105 and =e2 in A106 on down the line it works fine, but when I tr
putting =f1 in B105 I get an error message about a circular formula an
then it just displays 0 as the result. Any thoughts

 

[Ron Rosenfeld]

I have 56 alphanumeric characters in A1 to A56. I am using =rand() in
B1 to B56 and RANK in C1 to C56. This gives me a random number 1
through 56 to correspond with my 56 alphanumeric characters. I am then
using INDIRECT to shuffle the letters in a random order, and OFFSET to
organize them. For space concerns, I want to format the results
differently about 50 rows down on the sheet. When I try going =e1 in
A105 and =e2 in A106 on down the line it works fine, but when I try
putting =f1 in B105 I get an error message about a circular formula and
then it just displays 0 as the result. Any thoughts?

What is the formula in f1?


--ron