I need a cell to display the (text) content of 1 of 25 cells.
example: I have text content in all cells ranging A1:A25
I want cell B1 to display the content of 1 of these at random.
is there a function for this or do I need to use a macro?
all help welcome,
thankyou!
Bookmarks