Hello all,

I would like a function or formula that will select a random cell from a range of cells

A1:A5

But it cannot be repeated.

I have found lots when searching but not for both a cell range and non-repeatable.

Is it possible?

Any help would be fantastic!