Is there such an Excel Function?

[Mike]

Hi,

Is there such a function in Excel:

Circular(B1, 2, 5)

which will start in B1 printing twice numbers from 1 to 5, as follows:

1
2
3
4
5
1
2
3
4
5

If not, how such thing is doable?

Thanks,
Mike

 

[Mike]

Functions can only return results to the cell in which they are located.

In order to accomplish this task, you would need to either use a VBA macro that calls for data input (eg, the starting cell, number of cycles, and top number) or, if your starting cell will always be B1, you could set up formulas in column B going down as far as you might have results.

The VBA Macro would probably be more flexible.

In either event, it would be useful to know the range of possible parameters before starting a project like this.- Hide quoted text -

- Show quoted text -

What formula can be used to initiate the circularity?

 

[Clif McIrvin]

Functions can only return results to the cell in which they are
located.

In order to accomplish this task, you would need to either use a VBA
macro that calls for data input (eg, the starting cell, number of
cycles, and top number) or, if your starting cell will always be B1,
you could set up formulas in column B going down as far as you might
have results.

The VBA Macro would probably be more flexible.

In either event, it would be useful to know the range of possible
parameters before starting a project like this.- Hide quoted text -

- Show quoted text -

What formula can be used to initiate the circularity?


---

It's difficult to grasp just what you are wanting.

From VBA, perhaps the Range.AutoFill Method will do what you are asking.

As an aside, it's generally considered bad form to ask the same question
in different groups under different Subject Lines (Multi-posting).

I don't recall for sure, but I believe that Google Groups will allow you
to cross-post, which is acceptable. When cross-posting, replies from
one group also show up in the other group, so everyone has the
opportunity to see the entire discussion thread.

 

[Rick Rothstein]

This is not exactly what you asked for, but maybe you can make use of it.
Put this formula in B1..

=MOD(ROW(A1)-1,5)+1

and copy it down for 10 rows.

Rick




"Mike" wrote in message

Hi,

Is there such a function in Excel:

Circular(B1, 2, 5)

which will start in B1 printing twice numbers from 1 to 5, as follows:

1
2
3
4
5
1
2
3
4
5

If not, how such thing is doable?

Thanks,
Mike

 

[Mike]

What is the extent of possible parameters?  e.g. cell to start, number of repetitions, maximum number?

Rick formula above worked well,

Thanks all....Mike