Help with a formula:mOVING ALL ENTRIES

[windy58]

Is there a formula I can use to move the last entry in 2 columns from the bottom to the top at the same time moving all other entries down to fill the vacant spot?

This is what I have:

NAME 1
NAME 2
NAME 3
NAME 4

This is what I want:

NAME 2
NAME 3
NAME 4
NAME 1

I know I can do this with a macro but I wondered if there was an alternative.

[AlfD]

Hi!

Put this in B1 and copy down the other 3 rows:

=INDIRECT("A"&MOD(ROW(),4)+1)

If you want to deal with a different number of items, change the 4.

Alf